Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

formula about "sum("value1") if("value2"==2018)"

张征征 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.

2 answers

Public
Dmytro Zvazhii Flexmonster 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

Public
张征征 May 4, 2018

Thank you Dmytro!

Please login or Register to Submit Answer