Sum() in the If Condition

[markgraham123]

Hi all,

I was trying to sum the filed grouped by name in the if loop.

=If(Status=1,Sum(Aggr([Amount],Name)))

This is not giving any result.

Can someone please help here

[sunny_talwar]

May be this:

Sum({<Status = {1}>} Aggr(Only({<Status = {1}>} Amount), Name))

[markgraham123]

It's just giving 0 sunny.

[sunny_talwar]

Would you be able to share a sample?

[kkkumar82]

Hi

Can you put some dummy data.

Thanks

Kiran Kumar

[Anonymous]

Hi Mark,

Please try:

Sum(Aggr(Sum({<Status = {1}>} Amount), Name))

[markgraham123]

!Here is the sample application..

I was trying to do the calcualtions using the variables.

[Anonymous]

Hi Mark,'

Only function returns 0(Zero) if they is more than one value for a dimension

Regards

Neetha

[sunny_talwar · Accepted solution]

I see this:

[markgraham123]

Sunny its working for me.

Also, i'm trying to store the value of the Column's total in chart to a variable...

I can do it by storing the expression in Variabloe.

But due to req. constraints i wanna do it the other way.

Can we do it?