Set Analysis Case

[aarohipatel]

Hi All,

I have the following fields in one of my application:

1.YEAR_MONTH

2.ITD_PAID

I am trying to achieve the following case:

If YEAR_MONTH=2016 Then 0 Else Current Year ITD_PAID - Previous Year ITD_PAID.

Please advise

Thanks in advance.

[danilostochi]

Hi, check this out,

=if(YEAR_MONTH = '2016','0',Above(ITD_PAID))

[jyothish8807]

Hi Aaro,

Try this:

=sum(if(YEAR_MONTH = '2016','0',ITD_PAID - Above(ITD_PAID)))

[aarohipatel]

Hi Danil,

Sorry for missing part for my requirement.

I need  the sum (ITD_PAID)
If YEAR_MONTH=2016 Then 0 Else Sum(Current Year ITD_PAID)- Sum(Previous Year ITD_PAID).

Sorry once again.

Please advise.

Thank you!

[jyothish8807]

Hi Aarohi,

Did the solution mentioned above by me worked ? 

[aarohipatel]

Hi KC,

Sorry for missing part for my requirement in my initial post.

Like I mentioned to Danil,

I need  the sum (ITD_PAID)

ITD_PAID is an expression (This field is populated with  amounts)

If YEAR_MONTH=2016 Then 0 Else Sum(Current Year ITD_PAID)- Sum(Previous Year ITD_PAID).

Sorry once again.

Please advise.

Thank you!

[danilostochi]

hi,

see if it is, if not create an example with images.

[jyothish8807 · Accepted solution]

Hi Aarohi,

The same can be achieved by this expression.

=if(YEAR_MONTH = '2016','0',ITD_PAID - Above(ITD_PAID))

Just make sure you aggregate the data at year level. That mean one entry for each year and sort the table by year.

Please refer the attached.

[aarohipatel]

HI KC, 

How can I use this new field in a graph with YEAR_MONTH?

Even in the straight table, I cant use this new field calculation if I do not pull 'ITD_PAID'

Thanks!

[jyothish8807]

Hi Aarohi,

Try this.

I just hide the ITD_PAID field in both straight and bar chart.