Aggregate Formulas with 2 fields
(countif("STATUS"='SALE'))+sum("CALLS")
Trying to add the total of the CALL fields only if the Status field equals SALE.
Both of these formulas work fine when create them separate but when I combine them they do not work.
Does anyone have any suggestions on how to make this work?
Thanks