I am creating a formula to calculate gross profit ...
# suiteanalytics
a
I am creating a formula to calculate gross profit on each estimate (They don't want to use the native gross profit field for reasons......) My Formula: MAXIMUM (1 - (({item.cost}*{quantity})/NULLIF({amount},0)))*100 Is pulling in the incorrect value when there are multiple line items, only pulling the max cost, feels like I should be able to put SUM in the formula to work but have not been successful