TOTAL Column is not populating - AGGR Issue

[#1]

Hi Friends,

This expression not able to populates the TOTAL amount, can any one help me..

if(FILE_STATUS='OPEN',sum( {<[%GL_EFF_DT]={'>=$(vBillStartDt)<=$(vBillEndDt)'}>}ITEM_AMT),

sum({<[%REMOVAL_DT]={'>=$(vBillStartDt)<=$(vBillEndDt)'}>}ITEM_AMT))

[Anonymous · Accepted solution]

Try this:

sum(aggr(<your expression above here>, dimension1, dimension2...))

where dimensions1, 2, etc. are your chart dimensions

[#3]

try your same expression but use double quotes for your range values

if(FILE_STATUS='OPEN',sum( {<[%GL_EFF_DT]={">=$(vBillStartDt)<=$(vBillEndDt)"}>}ITEM_AMT),

sum({<[%REMOVAL_DT]={">=$(vBillStartDt)<=$(vBillEndDt)"}>}ITEM_AMT))

[ToniKautto]

Dimension are always relevant in order to understand how the aggregation is done.

You need to start by making sure that FILE_STATUS='OPEN' returns the value you expect. In a straight table add FILE_STATUS as an expression, and check that it returns OPEN on the rows where you expect it.

Split your expressions is separate chart expressions. Now you should have 4 expression in the chart. Does all these add up, or where is the mismatch? Can you provide a sample QVW file?

[#5]

Yes. I got correct reults once I aggregated with the dimensions that i have used.

sum(Aggr(if(FILE_STATUS='OPEN',sum( {<[%GL_EFF_DT]={'>=$(vBillStartDt)<=$(vBillEndDt)'}>}ITEM_AMT),

sum({<[%REMOVAL_DT]={'>=$(vBillStartDt)<=$(vBillEndDt)'}>}ITEM_AMT)),FILE_STATUS,Trans_Kind))

Thank you.