Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Apr 04, 2019 12:21 PM
Hello,
I am trying to create a table for our sales employees rolling bonus program. I have the main bones built, but I am struggling in one area.
I need a way to add values in a compound manner.
Example:
I need to use the rolling values of these for their commission statements.
Does anyone have any suggestions for a formula?
Thank you kindly :slightly_smiling_face:
Apr 04, 2019 12:37 PM
Do you mean compound or running total?
(I think of compund as being where they were paid $500 in Jan, and if they hit their target in Feb, they get a $500 bonus for feb in addition to a matching bonus for all months prior)
I didn’t build it out, but assuming it is a just a running total
Have a ‘Hit-Target’ table with 2 fields Text ‘months’ and Linked Field ‘Employees’
When an employee hits their target for a month, add them to that month.
Back in another table with the employees, where there is now a ‘Target-Hit’ field, use a $500*Count() on that field.