Formula Examples

This article provides a list of common formulas. Note that these formulas contain variables and calculations that may not be applicable to your organization. For more detailed information on formulas, see the following articles:

Examples

When reviewing the examples below, note that:

  • Variables represent numeric and date fields, select lists, workflow states, or other formulas; and
  • Functions require data from multiple objects. As such, only Relationship and Reference variable types can be used with a function.
NAME
FORMULA
VARIABLES
OPERATORS
FUNCTIONS
RESULT
Average ImpactMEAN(IMPACT)IMPACT (Inherent Impact)
MeanCalculates the mean value of Inherent Impact from objects in the Risks relationship, divided by the number of times the variable appears on the objects.
Control EffectivenessCONTROLEFFCONTROLEFF (Control Effectiveness)

Provides a count of the value from the Control Effectiveness field. Note that if a count of values from multiple objects is required, a relationship or reference variable type used with the sum function is required.
Design EffectiveDE==1?1:0DE (Design Effectiveness)== (equal to), ? : (conditional expression)
Checks if Design Effectiveness equals 1. If yes, the formula outputs 1, otherwise, it outputs 0.
Indicator Status(CURRENT-TARGET)*DIRECTIONCURRENT(Current Value), TARGET (Target Value), DIRECTION (Desired Direction)(  ) (grouping), - (minus), * (multiply)
Subtracts the value of Target Value from Current Value, then multiplies the total by the value of Desired Direction.
Inherent Risk ScoreIN_IMPACT*IN_LIKELIHOODIN_IMPACT (Inherent Impact), IN_LIKELIHOOD (Inherent Likelihood)* (multiply)
Multiples the value of Inherent Impact by the value of Inherent Likelihood.
KRI StatusTYPE==1 AND CV>LL AND CV<UL?1:2TYPE (Type), CV (Current Value), LL (Lower Limit), UL (Upper Limit)== (equal to), and (logical and), > (greater than), < (less than), ? : (conditional expression)
Checks if the value of Type is 1, if the value of Current Value is greater than Lower Limit, and if the value of Current Value is less than Upper Limit. If yes, the formula outputs a value of 1, otherwise it outputs 2.
Material WeaknessesIC==2?1:0IC (Issue Classification)== (equal to), ? : (conditional expression)
Checks if the value of Issue Classification is 2, If yes, the formula outputs a value of 1, otherwise it outputs 0.
Maximum LikelihoodMAX(LIKELIHOOD)LIKELIHOOD (Inherent Likelihood)
MaxCalculates the highest numeric value of Inherent Likelihood from objects in the Risks relationship.
Net LossTOTALLOSS-TOTALRECOVEREDTOTALLOSS (Total Loss Amount), TOTALRECOVERED (Total Recovered Amount)- (minus)
Subtracts the value of Total Loss Recovered from Total Loss Amount.
No. of Open Actions
SUM(OA)
OA (Open Actions)

Sum
Calculates the sum of values of Open Actions from objects in the Processes relationship.
Percentage of Samples Failed(SUM(FAILED))/(SUM(TESTED)*100FAILED (No. of Samples Failed) TESTED (No. of Samples Tested) Control / (divide), * (multiply)SumDivides the sum of values of No. of Samples Failed by the sum of No. of Samples Tested from objects in the Tests relationship, then multiplies the total by 100.
Percentage of Testing CompleteTESTING/PLANNED*100TESTED (No. of Samples Tested), PLANNED (Total Samples Planned)/ (divide), * (multiply)
Divides the value No. of Samples Tested by Total Samples Planned, then multiplies the total by 100.
Time to FixtimeDiff
(DATECOMPLETED,DATEIDENTIFIED,"days")
DATECOMPLETED (Issue Resolution Date), DATEIDENTIFIED (Issue Identification Date)
timeDiffDisplays the difference, in days, between the Issue Resolution Date and the Issue Identification Date.
Total CostQTY*COSTQTY (Quantity), COST (Cost)* (multiply)
Multiples the value of Quantity by Cost.