Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was just exploring Old Community threads and found this one Limit Dimensions by Calculated Expression
The solution in this thread is working fine however I am not able to make much sense out of it. The way I am trying to understand the below expression is- IF function would be evaluated first. So it will filter out all the items not fulfilling this condition and then the outer function Aggr would be evaluated with the filtered data.
=aggr(if(SUM(LINE_SPEND_AMOUNT)>50000, [Supplier Name]),[Supplier Name]
However, this function seems to be working in a different way aggr is getting evaluated first.. so, it is first evaluating aggr to group LINE_SPEND_AMOUNT by Supplier Name and then If function plays it's role by filtering out data not fulfilling the condition.
Attaching my QV doc to better understand this.
Kind of .
Thanks all for your help!! Have a wonderful day.