Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

I pay my contractors biweekly a different percentage of the revenue brought in

Topic Labels: Base design
243 0
Showing results for 
Search instead for 
Did you mean: 

I have two tables on air-table.
One for Staff, another for Leads.

Staff: grouped under type: organic sales, paid sales, and coaches.
Fields: Type, Total Revenue, Total Leads.

Two questions:

  1. How can I change the formula for each staff type?
  2. How can I calculate the total revenue biweekly? and reset it every biweekly period? The amount to be paid to the contractors is based on the revenue brought in in each of the 26 periods of the year.
0 Replies 0