How to Aggregate in a Set Analysis

Anonymous — Thu, 12 Jul 2018 13:38:20 GMT

I am working on a app which analyses Spend.

Refer the sample table below

The logic in the "Spend" Column the checks if we have a value in the "IR" column if not it reports the value in "GR" column.

I created a variable Spend with the below logic.

IF((IR=0),GR,IR)

Now this logic works well in a table as seen below.

But I have not been able to use the logic in a KPI chart in a set analysis for total Spend for Current year.

Can some one please provide suggestions as to what is the best function to use. I wasn't able to get Aggregate function to work

Re: How to Aggregate in a Set Analysis

brunobertels — Thu, 12 Jul 2018 15:57:40 GMT

Hi may be this

Sum(Aggr(

if(IR=0,sum(GR),Sum(IR),Year))