Calculating Pay based on Work Type - Airtable Community

PHOTO EMBED

Tue Aug 01 2023 13:58:02 GMT+0000 (Coordinated Universal Time)

Saved by @cddouglass #auto

SWITCH(
  {Work Type},
  "WAE - Club Booked", (MAX({Revenue} - 125, 0)*.2) + 125,
  "WAE - Club Not Booked", ({Revenue}*.4),
  {Custom Rate}
)
content_copyCOPY

https://community.airtable.com/t5/formulas/calculating-pay-based-on-work-type/td-p/39526