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)

Here is an example syntax for displaying the largest tsf number out of 3 groups, you would just need to enter the relevant info in the {} brackets as explained above (you can of course change the stat to whatever you wish it doesn't have to be TSF.

To show the smallest number simply change > to <

( {$PBXname/Groups|Sales|tsf} > {$PBXname/Groups|Membership|tsf} ) ? ( ({$PBXname/Groups|Sales|tsf} > {$PBXname/Groups|Support|tsf} ) ? {$PBXname/Groups|Sales|tsf} : {$PBXname/Groups|Support|tsf} ) : ( {$PBXname/Groups|Membership|tsf} > {$PBXname/Groups|Support|tsf} ) ? {$PBXname/Groups|Membership|tsf} : {$PBXname/Groups|Support|tsf}

## Comments

0 comments

Please sign in to leave a comment.