Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi Aarohi,
Try this. Best approach to fulfill your requirement will be to create the fields in the back end.
Hi, check this out,
=if(YEAR_MONTH = '2016','0',Above(ITD_PAID))
Hi Aaro,
Try this:
=sum(if(YEAR_MONTH = '2016','0',ITD_PAID - Above(ITD_PAID)))
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!
Hi Aarohi,
Did the solution mentioned above by me worked ?
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!
hi,
see if it is, if not create an example with images.
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.
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!
Hi Aarohi,
Try this.
I just hide the ITD_PAID field in both straight and bar chart.