Error on Sum Expression Aging Report

[Anonymous]

[Lisa_P]

Set Analysis should be the solution. Try this ..

Sum({<Age={">=0<=30"}>}OpenBalance)

[jyothish8807]

Try like this:

sum(if((Age>0) and (Age<=30),OpenBalance,0))

or

Sum({<Age={">=0<=30"}>}OpenBalance)

Br,

KC

[kaushiknsolanki]

Hi,

Use aggr function like below.

Sum(Aggr(If Statement....,DImension1,DImension2))

Regards,

Kaushik Solanki

[Anonymous]

[tresesco]

Age and OpenBalance are not fields in your data model. They look to be labels. And labels can't be aggregated (using sum() here). To get the same result from another column in aggregation function, you could rather use the same expression. If you could provide a sample app and explain expected output, it would be easier for us to help.