archerrsa-archer-grc

Is there a way to store sum using calculated fields in RSA Archer GRC?

There are two fields. The first contains numeric value. The second should contain the sum of the all changes of the first field. Can I use calculated field for this task? If so what would be inside the formula?

For example:

Update 1 First field changed manually to 100. Second automatically contains 100.

Update 2 First field changed manually to 200. Second automatically contains 300.

Update 3 First field changed manually to 100. Second automatically contains 400.

Solution

  • Calculations can reference themselves.

    So, for example, let's say you have a numeric field named Total Sum. For that field, you would use the following calculation SUM([Field with value],[Total Sum])