AnsweredAssumed Answered

Need help with the Case function

Question asked by MH on Mar 8, 2013
Latest reply on Mar 8, 2013 by philmodjunk

Title

Need help with the Case function

Post

     Would appreciate any help with a problem creating a correct Case function.

     Here's what I have, followed by a description of what it's supposed to do:


     Case
     ( Number of Days <=28;Choose (Number of Guests ; 0; 20; 35; 45.5; 56);

     Number of Days ≥ 28;Choose (Number of Guests ; 0; 17; 30;40.5;51);

     Number of Days  ≥ 42;Choose (Number of Guests ; 0; 16; 28; 38; 48);

     Number of Days ≥ 56;Choose (Number of Guests ; 0; 15; 26; 35; 45);

     +(Number of Guests*Number of Days)+Other Fee-Credit)

      

     What it is supposed to do is perform a calculation based on:

             -a- If less than 28 days, calculate the Number of Days multiplied by the Number of Guests (1 guest = $20, 2 guests = $35, 3 guests = $45.5, 4 guests = $56).

             -b- Then if the Number of Days is equal to or greater than 28  days but less than 42 days, the next rates are $17, $30, $40.50, $51

             -c- Subsequently, if the Number of Days is equal to or greater than 42 but less than 56 days, the rates applied are $16, $28, $38, $48

             -d- And finally, if the Number of Days is equal to or greater than 56, the best rates given are $15, $26, $35, 45 - again corresponding to the Number of Guests.

     The problem is that the database is only recognizing/reading the first two arguments (-a- and -b-) and ignoring the last two.

Outcomes