Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Set Analysis should be the solution. Try this ..
Sum({<Age={">=0<=30"}>}OpenBalance)
Try like this:
sum(if((Age>0) and (Age<=30),OpenBalance,0))
or
Sum({<Age={">=0<=30"}>}OpenBalance)
Br,
KC
Hi,
Use aggr function like below.
Sum(Aggr(If Statement....,DImension1,DImension2))
Regards,
Kaushik Solanki
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.