 While trying to find a solution to a problem I'm having with a FMP file I'm writing, I came across an article by you regarding FMP's CASE function. I am not at a developer, just a regular joe trying to learn and develop a couple of small files, not at all well versed in the intricacies of building a sophisticated DB.

Would help me solve my dilemma? I'd be appreciative if you would I've studied and researched and fought endlessly to figure out why my formula won't work. Probably a simple fix but one that is eluding me.

I'm using FMP 9 and trying to incorporate the CASE function as shown below.

Case(
Number of Days <28 and Number of Guests = 1; 20;
Number of Days <28 and Number of Guests = 2; 35;
Number of Days <28 and Number of Guests = 3; 50;
Number of Days <28 and Number of Guests = 4; 65;
Number of Days <28 and Number of Guests = 5; 80;
0)
+
Case(
Number of Days   ≥ 42  < 56 and Number of Guests = 1; 15;
Number of Days   ≥ 42  < 56 and Number of Guests = 2; 11;
Number of Days   ≥ 42  < 56 and Number of Guests = 3; 9.5;
0)
+
Case(
Number of Days   ≥ 56 and Number of Guests = 1; 10;
Number of Days   ≥ 56 and Number of Guests = 2; 8;
Number of Days   ≥ 56 and Number of Guests = 3; 7;
0)

I've attempted to use IF statements but failed there as well. I am ruthlessly busy and cannot support things like this as much as I like ... but ... I did give it a quick "first cup of coffee" shot at it. Since the "number of guest" part of the puzzle was linear, I tried the "Choose" function. I don't use it that often but I think the enclosed file might work.  Choose is a neat little function that seems a little odd, at first. It first will perform a test and return a number that is equal to or greater than zero. Then it will follow with a number of expressions that will link to that number. I have written about it before ( click here ).