JonathanHeuer
4 years agoQrew Cadet
Using the result of one report formula in another
I'm trying see how we're doing in customer acquisition costs. I have a summary report which tabulates the cost of each lead:
The Converted Leads column is a report formula (formula-checkbox where Status field = "Converted"). I'd like to add 2 more columns:
------------------------------
Jonathan Heuer
------------------------------
The Converted Leads column is a report formula (formula-checkbox where Status field = "Converted"). I'd like to add 2 more columns:
- Cost per Conversion. For a given month, this would equal the number of conversions divided by the total cost (so, the 2nd column/1st column).
- Conversion Percentage. For a given month, this would equal the number of conversions divided by the total number of leads (so, 2nd column/3rd column)
------------------------------
Jonathan Heuer
------------------------------