AnsweredAssumed Answered

A Question About Case

Question asked by clarapippa on Sep 6, 2016
Latest reply on Sep 6, 2016 by BruceRobertson

Alright, my nested IF statement was ugly so I thought to try CASE instead... Here's a snippet of my calculation field:

 

...

(Length  ≤ "120") and (Diameter  ≤ "6") ; "Standard Box, Thick/Thick" ;

(Length  ≤ "120") and (Diameter  ≥ "6.1" and Diameter  ≤ "10") ; "Standard Box, Thick/Thin" ;

(Length  ≤ "165") and (Diameter  ≤ "5") ; "Long Thin Box, Thick/Thick" ;

(Length  ≤ "165") and (Diameter  ≥ "5.1" and Diameter  ≤ "7") ; "Long Thin Box, Thick/Thin" ;

...

 

Now, I have a record that has a Length of 100 and a Diameter of 6.35 yet it's skipped "Standard Box, Thick/Thin" and landing on true for "Long Thin Box, Thick/Thin" ... Huh?? Does anyone have any idea why this might be? Do I have a backwards less than/greater than symbol and I'm just going mad?

 

Thanks for the double check.

Outcomes