Switched True with multiple less than greater than expression format

[Anonymous]

Good day everyone.  I Have a matrix our renewal team wants me to apply to our sales team where I compare a team member's contract renewal RUN RATE, [how many of the contracts did they get renewed], by their ability to renew the contract ON TIME to calculate their percentage payout.  I have attempted to leverage a SWITCH TRUE statement to capture 16 payout brackets however, I'm getting 0 for all team members but I am expecting to have matched two team members at 10% right now, based on having a 75%  run rate and less than 70% on-time rate.   I fear I've either miss formatted my Switch Statement, or I'm attempting to accomplish something that may be better accomplished via an alternate means.  I have validated that my Variables are functioning providing an accurate reflection of RunRate and OnTime.  Below are my switch Statement and the matrix I'm attempting to accomplish with this measure.  Thank you in advance for guidance and or recommendations on solving this measure requirement.

Payout =
VAR RunRate =
DIVIDE ( [Count IS Renewal Opps Closed Won], [Count IS Renewal Opps Closed], 0 )
VAR OnTime =
DIVIDE ( [Count IS On Time Renewals], [Count IS Renewal Opp], 0 )
RETURN
SWITCH (
TRUE (),
ISBLANK(RunRate) && ISBLANK(OnTime), VALUE(0),
RunRate >= 90 && OnTime >= 90, VALUE(120),
RunRate >= 85 && RunRate < 90 && OnTime >= 90, value(110),
RunRate >= 90 && OnTime >= 80 && OnTime < 90, Value(110),
RunRate >= 85 && RunRate < 90 && OnTime >= 80 && OnTime < 90, VALUE(100),
RunRate >= 90 && OnTime >= 70 && OnTime < 80, VALUE(95),
RunRate > 75 && RunRate < 85 && OnTime <= 90, VALUE(80),
RunRate >= 85 && RunRate < 90 && OnTime >= 70 && OnTime < 80, VALUE(80),
RunRate >= 75 && RunRate < 85 && OnTime >= 80 && OnTime < 90, VALUE(75),
RunRate >= 90 && OnTime < 70, VALUE(75),
RunRate >= 75 && RunRate < 85 && OnTime <= 70 && OnTime < 80, VALUE(50),
RunRate >= 85 && RunRate < 90 && OnTime < 70, VALUE(50),
RunRate >= 75 && RunRate < 85 && OnTime < 70, VALUE(25),
RunRate < 75 && OnTime >= 90, VALUE(10),
RunRate < 75 && OnTime >= 80 && OnTime < 90, VALUE(10),
RunRate < 75 && OnTime >= 70 && OnTime < 80, VALUE(10),
RunRate < 75 && OnTime < 70, VALUE(0)
)

[mahoneypat · Accepted solution]

If your two variables are generating percentages, none of your SWITCH evaluations would be above 1.  Try multiplying both variables by 100.

Regards,

Pat

[Anonymous]

Man, I cannot believe I missed that.  Thank you SO much @mahoneypat   Thank goodness BI is a Team sport!  😄