Forum Discussion
AMPAllie
3 years agoHelper II
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
- lbendlinSuper User
Do you want to show this by quarter? Can you indicate the expected result?