1 Reply Latest reply: Jun 19, 2017 6:43 PM by Sunny Talwar

# Multiplication inside Sum with Total

I'm trying to create a function that is essentially:

SUM(colA * colB * Total ColC)

But it's returning nothing.

The actual expression is a little more complicated:

If(Sum(count) <> 0, Sum([Number of Tickets]),

Sum([curves.curve]*[OP.tixrsrperc]*

TOTAL {<[OP.week_ending_date] = {"\$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>}count

/

TOTAL {<[OP.week_ending_date] = {"\$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>}[curves.curve]

)

)

I verified all the individual parts work as expected.  Any ideas?

• ###### Re: Multiplication inside Sum with Total

May be this

Sum(Aggr(

Sum([curves.curve])*Sum([OP.tixrsrperc]) *

Sum(TOTAL {<[OP.week_ending_date] = {"\$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>} count)

/

Sum(TOTAL {<[OP.week_ending_date] = {"\$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>}[curves.curve]), UniqueIdentifierField))