I’m trying to calculate three values with the data of last year and this year，the year-on-year ratio,the sum of this month and the sum of this year.
I have tried some formula,like sum(“value1”) if(“year” == 2018),but it doesn’t work.
Please let me know if any resolution is available for this issue.
Thank you for writing. The above formula is not correct. We recommend using UI tool for setting calculated values. Please have a look at the following example: https://www.screencast.com/t/cn29F2GLe. Therefore the correct setting will be the following:
if("year" == 2018, sum("value1"), 0)
Please let us know if you have any additional questions.
Thank you Dmytro!