Archer GRC calculation based on percentage

269 Views Asked by At

I have two numeric type fields to base a calculation on. I want the third field type to display the correct percent, which I want resulting in 20% (1/5):

([Number Comments Adopted]/(COUNT([Number Comments Submitted])))

Current result:

enter image description here

1

There are 1 best solutions below

0
On BEST ANSWER

The following calculation formalar should work for "Percent Adopted" field:

100*[Number Comments Adopted]/[Number Comments Submitted]

Field "Percent Adopted" has property "Suffix" set to "%" and property "Decimal Places" set to "2".

Tested examples:

enter image description here enter image description here

Good luck!