Forum Discussion

LoriDavidson's avatar
LoriDavidson
Qrew Trainee
10 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 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


Formulas and functions
Relationships
Tables and fields

2 Replies

Sort By
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    10 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