Archer GRC calculation based on date and value list fields
I have two fields I need to calculate. One is a date field which the initial data is received via a data feed, the other is a radio button field with the values: [] None; [] 6 months; [] 1 year; [] 2 years, [] 3 years; [] Permanent.
I need to calculate the date field + the radio button where I add 181 days for 6 months, 366 for 1 year, 731 days for 2 years, 1096 days for 3 years, and finally show the date December 31, 2099 if the date is Permanent.
[Date] + [Radio Button]
Solution
Figured it out, just needed to utilize archers VALUEOF and DATEFORMAT to get the correct calculation:
IF ([Radio Button] = VALUEOF([Radio Button],"6 months"),
[Date] + "181",
IF ([Radio Button] = VALUEOF([Radio Button],"1 Year"),
[Date] + "366",
IF ([Radio Button] = VALUEOF([Radio Button],"2 Years"),
[Date] + "731",
IF ([Radio Button] = VALUEOF([Radio Button],"3 Years"),
[Date] + "1096",
IF ([Radio Button] = VALUEOF([Radio Button],"None"),
[Date],
IF ([Radio Button] = VALUEOF([Radio Button],"Permanent"),
DATEFORMAT("12/31/2099", "MMddyyyy")))))))
- 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
- Unable to delete Access Role in RSA Archer
- Is there a way to store sum using calculated fields in RSA Archer GRC?
- Archer GRC Automated Deployments
- Archer GRC Test Automation with Selenium
- How to get ID's of the records in Cross-reference field using Web API in RSA Archer?
- 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?
- Is there a way to write scripts in RSA Archer so Archer can call an API to trigger other web applications?
- RSA Archer: Get mail's attachments with mail monitor data feed
- How to remove a workflow
- API Call from advanced workflow
- RSA Archer: How to execute a Data Feed from an Application
- RSA Archer Field Error: A parameter expected to be a single value was multiple values
- Archer GRC calculation based on date and value list fields
- 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
- 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?
- Identify record editor in Archer GRC