AnsweredAssumed Answered

Help with Cases

Question asked by MikeBriganti on May 27, 2015
Latest reply on May 28, 2015 by MikeBriganti

Title

Help with Cases

Post

Hello, I am trying to create a case for some calculated fees based on attendance numbers. I have pasted the script below. The first two cases work perfectly. However, when I enter "100" as my TotalAttendance, the CalculatedFees returns as "175" and I do not understand why.

Thanks in advance for any help.

Script:

 

Case
(
          (TotalAttendance ≤ 50);
          175;

          (TotalAttendance > 50  and TotalAttendance  ≤  79);
          (175 + 6 * (TotalAttendance - 50));

          (TotalAttendance > 79  and TotalAttendance ≤ 100);
          350;

          (TotalAttendance > 100  and TotalAttendance ≤ 129);
          (350 + 6 * (TotalAttendance - 100));

          (TotalAttendance > 129  and TotalAttendance ≤ 150);
          525;

          (TotalAttendance > 150  and TotalAttendance ≤ 179);
          (525 + 6 * (TotalAttendance - 150));

          (TotalAttendance > 179  and TotalAttendance ≤ 200);
          700;

          (TotalAttendance > 200  and TotalAttendance ≤ 229);
          (700 + 6 * (TotalAttendance - 200));

          (TotalAttendance > 229  and TotalAttendance ≤ 250);
          875;

)

Outcomes