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.