asked on May 3, 2018
Hi,
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.
⋅ May 3, 2018
Hello 张征征,
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.
Regards,
Dmytro
⋅ May 4, 2018
Thank you Dmytro!
