8 Replies Latest reply on Apr 21, 2014 4:34 AM by radion1

    Pattern Count with nested if statements problem

    radion1

      Hi ,

       

      I have a calculated list of options for a particular category of cafe item

      E.g

       

      Field 1 Category - coffee

       

      Field 2 Checkbox list

      - soy

      - decaf

      - double

      - skim

      - 1 sugar

       

      If a coffee has soy it costs .50c extra, decaf .20c strong .20c this adds to the normal price.

      So I used a nested if statement with pattern count and if it's one of those items then it works fine.

      If there are 2 selections ( soy decaf) it always reverts to the price of just soy and doesn't add the decaf price

      My if statements seem to cover all the possibilities but the calculation always reverts to the first option.

       

      Can I use multiple items in the pattern count search string ?

      Why does it revert to the first item ? Is pattern count the wrong approach ?