Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am working on a commission sheet for my team.
Criteria for this commission is if Gross Margin is greater than 25% and over all HCP count is greater than 8 the Tier commission is 20%. At the same time, if the same gross margin is expected but more than 25 HCPs the tier commission should be 25% for that line.
I have included a photo below to help.
Hello,
try:
Commission = SWITCH(
TRUE(),
[Gross Margin] > 0.25 && [HCP Count] > 25, 0.25,
[Gross Margin] > 0.25 && [HCP Count] > 8, 0.2,
BLANK()
)
If this solved your problem, please mark it as the solution, so others can find it 🙂