2 Replies Latest reply on Aug 17, 2018 12:32 PM by Maxanne Durkee

    Use complicated Grand Total in calculated field

    Maxanne Durkee


      Due to the way my data is blending, I am using the median of the number I am then adding up in the end for a grand total.


      I need to use that grand total in other calculated fields.


      So for the Expense total field I need to use that 33,692 (in this case) to calculate costs like cost per lead.

      If I attempt to use sum() it will sum all the values in the database which are duplicated so I need to use the sum of the median.

      Any ideas?


      Thanks in advance.