Archer GRC calculation based on percentage
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:
Solution
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:
Good luck!
- How would you increment a value when every time a single record is rejected multiple times?
- I am not able to apply conditional layout to a particular user/group field but can do it manually for any user
- Is there a way to store sum using calculated fields in RSA Archer GRC?
- How to get ID's of the records in Cross-reference field using Web API in RSA Archer?
- Is there a function in Archer that could draw a line separating two outputs in a single field?
- I am trying to import data into Archer from an XML file using File Transport data Feed. But no records are getting created
- RSA Archer data feed uses plaintext password
- How to count the number of records in cross-reference field in RSA Archer GRC?
- How to execute script on every tab changing in RSA Archer GRC?
- How to get current session token in RSA Archer?
- RSA Archer: Get mail's attachments with mail monitor data feed
- How to stop rendering feature points in ARcore with unity
- How to remove a workflow
- API Call from advanced workflow
- RSA - Archer - Hide multiple fields in a search result
- Customize an Archer Application from an external Application
- Archer GRC Calculation based on three fields
- Validation for not allowing same users to be selected in record permission field in two different applications in RSA Archer
- How can I abort deletion of record on click of delete button?
- Archer GRC: Calculate current date when values list changes
- Archer GRC: Formula based on setting current date between specific time frames
- Archer GRC: Calculate number days between two date fields
- Suds Type not found error
- RSA Archer - Calculated field based on date field
- How to make the Automatic Record Permission field to update itself as quickly as possible?
- Archer GRC calculation based on percentage
- How to prevent a data feed from creation of duplicate records in RSA Archer platform?
- RSA Archer Show Filters
- Identify record editor in Archer GRC
- Calculation from Value-List in Archer GRC based on date (with non-empty validation)