2 Replies Latest reply on Sep 27, 2018 6:34 AM by Vlad Makarov

    Unable to properly SUM multiple calculated fields

    Vlad Makarov

      Good day all, need some help from the experts!


      I have a workbook containing several calculated fields in which I receive a count of records on each relevant field.

      From there I am looking to create another calculated field that adds them all together, while also applying some additional arithmetic.


      For example:


      (SUM([FIELD1]*0.2 +[FIELD2]*1+[FIELD3]*2+[FIELD4]*2+[FIELD5]*3+[FIELD6]*4+[FIELD7]*4))


      The last column at the end of the screenshot should be adding the other fields based on the SUM calculation above, but nothing appears. I checked all fields are displaying as numbers, not sure what I am doing wrong.



      Thanks in advance.