Get Free Trial
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 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