Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Sum({<Status = {1}>} Aggr(Only({<Status = {1}>} Amount), Name))
It's just giving 0 sunny.
Would you be able to share a sample?
Hi
Can you put some dummy data.
Thanks
Kiran Kumar
Hi Mark,
Please try:
Sum(Aggr(Sum({<Status = {1}>} Amount), Name))
!Here is the sample application..
I was trying to do the calcualtions using the variables.
Hi Mark,'
Only function returns 0(Zero) if they is more than one value for a dimension
Regards
Neetha
I see this:
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?