Forum Discussion
Help with pulling in formula using Swith function
I have case where I have created buckets to indicatite where a rolling 6-month average of total sales fall in relation to a bonus. So for example, if rolling average of sales are less than 5000, the...
Most likely you need to change the order of the checks in the SWITCH statement. Remember that SWITCH exits as soon as the condition evaluates to TRUE()
Thanks...do you know what I would be switching?
SWITCH ( TRUE (), SELECTEDVALUE ('Sales'[exceptioncheck1] ) = 1, .85, SELECTEDVALUE ( 'Sales'[exceptioncheck2] ) = 1, .65, [6MRA] >= 0 && [6MRA] < 5000, .50, [6MRA] >= 5000 && [6MRA < 10000, .60, [6MRA] >= 10000 && [6MRA] <20000, .70, [6MRA] >= 20000 && [6MRA] < 30000, .80, .90 )
The exceptioncheck part of this formula is just because 2 agents have an automatic rate regardless of the actual sales number, i don't believe that would impact anything