sum expression in template

[BOTFORCE]

Dear all,

I have a question. When I add the following expressions into my template, I get all the values of the volumes separate. How can I sum up all the values together in one expession?

<<[Related Investments By Financial Advisor][Volume]>>

<<[Related Investments By Sales Person][Volume]>>

<<[Related Investments By Introducer][Volume]>>

I tried this, but doesn't work:

<<
SUM(
SUM(SELECT([Related Investments By Financial Advisor][Volume],true)),
SUM(SELECT([Related Investments By Sales Person][Volume], true)),
SUM(SELECT([Related Investments By Introducer][Volume],true)))
>>

Thx, Robert

[Marc_Dillon · Accepted solution]

SUM() requires a List type as the argument, whereas you're feeding your outer SUM() 3 values separated by commas.

Either one of these would work, the first one using "List Addition":

SUM( [Related...][Volume] + [Related...][Volume] + ... )

or

SUM([Related...][Volume] ) + SUM([Related...][Volume] ) + ...

[BOTFORCE]

Thanks Marc!!