How can I create a formula to determine cost per person?

Question

Hi, I am trying to create a formula to determine the cost per person. For example, the total amount spent was $10,000, I need to know the cost per person (from two separate fields). Total # of employees + total # of customers/total cost for event=cost per person

Also, is there a reference guide for writing formulas?

Thanks for your help, Lori

archiveuser · Answer

Hi Lori,

Assuming you're already tracking these three data points on the table, you've got the right math there. You would add a Formula - Numeric field with this formula:

([Total # of employees] + [total # of customers]) / [total cost for event]

If you need help pulling the above three figures onto the same table, please let us know!

Thanks,

Brian

loridavidson · Answer

Thank you Brian, this was very helpful!

Forum Discussion

How can I create a formula to determine cost per person?