2 Replies Latest reply on Aug 7, 2018 7:47 AM by Priya Jyothibabu

    Issue with adding calculated fields made up of IF statements

    Priya Jyothibabu

      I am using many calculated fields created using IF statement. These are further used in calculations involving addition and then division of the summed values. I am getting null when adding the values which are otherwise giving me correct data when used individually. I tried using ABS, ZN, etc in the calculated fields. ZN is giving me 0 as the answer of the addition whereas I am able to display the values in the same sheet. Please help with a work around for this. Please let me know if you would need more information to resolve this.