This content has been marked as final. Show 2 replies
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.
Thanks in advance.