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

    Use complicated Grand Total in calculated field

    Maxanne Durkee

      Hello,

      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.