Skip to main content
Conga Support

Simple Calculation Functions and Operators

This page applies to: Analytics Add-on module

A Simple Calculated field added to an Analytics Report can contain both functions and operands to create the formula.

Function

Icon

Description

Count

image385.png

Count the number of items

Count Distinct

image386.png

Count the number of items that are distinct

Sum

image381.png

Add the values

Average

image382.png

Calculate the average value

Minimum

image384.png

Use the minimum value

Maximum

image383.png

Use the maximum value

 

Operator

Icon

Description

Add

image392.png

Perform addition

Subtract

image393.png

Perform subtraction

Multiply

image394.png

Perform multiplication

Division

image395.png

Perform division

Open Parenthesis

image396.png

Insert open parenthesis – the formula inside parentheses is performed first

Close Parenthesis

image397.png

Insert close parenthesis – the formula inside parentheses is performed first

Case

image398.png

Select if you want to set up an If…then statement. The When, Else, and End options are enabled to create the statement.

When

image399.png

Defines the condition that must be met (i.e., WHEN), and also defines the THEN result to establish what should be returned by the calculation when the WHEN condition is met.

Else

image400.png

Defines what should be returned by the calculation if none of the WHEN conditions are met.

End

image401.png

Select to end the conditional calculation (If…then statement).