Forum Discussion

AMPAllie's avatar
AMPAllie
Helper II
3 years ago

Measure with IFS or Filters

I need to calculate recruiting bonuses for two different people with two different criteria.

The logic is as follows
Billy: ((Billy's New Hires minus Terms) * 300) + ((Derek's New Hires minus Terms)*200)
Derek: ((Derek's New Hires minus Terms) * 300) + ((Billy's New Hires minus Terms)*200)

I've tried if statements, Calculating and filtering...but I can't seem to get the syntax right.  In the "recruiter" column there will also be N/A besides the two names.

1 Reply

  • Do you want to show this by quarter?  Can you indicate the expected result?