The advanced formula option in the calculated values element use the following syntax for a data source:

{$connectorname/feedname|tablename|fieldname}

e.g. {$PBXname/Groups|Sales|tsf}

This will display the tsf value of the sales group.

You then add the operation you want + - / x (i.e. add, subtract, divide, multiply)

The operation needs to be outside of the curly brackets ( { } )

Then enter the next data source formula as above.

The entire formula created should be within brackets ( )

e.g. The following example combines tsf values together then divides by 3 to find the average tsf.

( {$PBXname/Groups|Sales|tsf}+{$PBXname/Groups|Support|tsf}+{$PBXname/Groups|Service|tsf} / 3)

## Comments

0 comments

Please sign in to leave a comment.