Forum Discussion

LoriDavidson's avatar
LoriDavidson
Qrew Trainee
11 years ago

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

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 empl...
Formulas and functions
Relationships
Tables and fields
ArchiveUser's avatar
ArchiveUser
Qrew Captain
11 years ago
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