topic If Statement without condition in App Development

If Statement without condition

dineshraj — Tue, 01 Aug 2017 09:53:09 GMT

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 — Tue, 01 Aug 2017 09:57:01 GMT

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 — Tue, 01 Aug 2017 10:04:34 GMT

Hi Dineshraj,

Aggr is used for group by purpose.

Thanks,

Arvind Patil

rahulpawarb — Tue, 01 Aug 2017 10:12:17 GMT

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:

Output:

FiscalMonth	aggr(if(Sum(Amount),Sum(Amount)),FiscalMonth)
1	9000
9	3000

Regards!

Rahul Pawar

dineshraj — Tue, 01 Aug 2017 10:14:48 GMT

Hi Chanty,

Can you explain with an Example