Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sum (TRX)/(Sum(TOTAL(TRX))/Count(DISTINCT(ZIP_CODE))) - this formula works fine but i am facing issues when i replicate this formula in another expression which is
fabs(Sum(TRX)-(Sum ({$<WEEK_END_DATE={"$(=date( max(WEEK_END_DATE)-7))"}>}TRX)))
/
(sum(TOTAL(fabs(Sum(TRX)-(Sum ({$<WEEK_END_DATE={"$(=date( max(WEEK_END_DATE)-7))"}>}TRX))))))/ (Count(DISTINCT(ZIP_CODE)))
can anyone tell me where im going wrong, the formula does not show an error
Could you send sample qvw file?
Sum over the sum is not possible.
Can you tell me what is your requirement?
Aggr is the only way to use sum over the sum like
Sum(Total Aggr(Fabs(Sum(FieldName)), DimField))