3 Replies Latest reply on May 17, 2018 9:09 AM by jodi schreiber

    Calculations with a constant

    jodi schreiber


      I have a dataset that looks like the below.


      I need to create a calculation that takes the total of the Gross Cost Amt and divides it by the total of just month tot mbrs.

      So for example my result should be : $588,688.40/39,709,609 but what is actually happenng is

      $588,688.40/the sum of the whole total mbrs column.

      Can anyone suggest a way to do this.