Get Free Trial

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

张征征 asked on May 3, 2018

    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

Dmytro Zvazhii 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: Therefore the correct setting will be the following: if("year" == 2018, sum("value1"), 0)
Please let us know if you have any additional questions.

张征征 May 4, 2018

Thank you Dmytro!

Please login or Register to Submit Answer