2 Replies Latest reply on May 28, 2015 9:34 AM by MikeBriganti

    Help with Cases

    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;

      )