Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

use of total when fabs is used

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

2 Replies
Not applicable
Author

Could you send sample qvw file?

CELAMBARASAN
Partner - Champion
Partner - Champion

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))