If Statement without condition

[dineshraj]

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

[Chanty4u]

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

[arvind_patil]

Hi Dineshraj,

Aggr is  used for group by purpose.

Thanks,

Arvind Patil

[rahulpawarb]

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

[dineshraj]

Hi Chanty,

Can you explain with an Example