Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] ) )
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?
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))
