Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am going through an expression.I find it difficult to understand the below expression.
aggr(if(Sum(Amount),Sum(Amount)),FiscalMonth)
Can anyone explain about this?
Thanks in advance
it is :
if the sum of amount is 100 it will display 100 based on fiscal month
aggr will be used over the dimension to caluclate
Hi Dineshraj,
Aggr is used for group by purpose.
Thanks,
Arvind Patil
In above straight table, AGGR expression will create a logical table with columns - FiscalMonth & Sum(Amount).
It will display these two columns if respective FiscalMonth has Sum(Amount) > 0.
Input:
Date | FiscalMonth | Amount |
01/01/2017 | 9 | 1,000 |
01/10/2017 | 9 | 2,000 |
04/04/2017 | 1 | 5,000 |
04/05/2017 | 1 | 4,000 |
06/04/2017 | 3 | 5,000 |
06/05/2017 | 3 | -5,000 |
Output:
FiscalMonth | aggr(if(Sum(Amount),Sum(Amount)),FiscalMonth) |
1 | 9000 |
9 | 3000 |
Regards!
Rahul Pawar
Hi Chanty,
Can you explain with an Example