4 Replies Latest reply: May 15, 2014 9:55 AM by Bill Tilghman RSS

    Odd calucated field reaction.

    Bill Tilghman

      The caculate field below has an interesting bit of drama!

      if(rr="1VM", "Victor Munoz", If(rr="1sc","Sean Cooper",if(rr="PAY", "Commission Flag",[b]if("RR"="1EM","Eric Menzer",[/b] If(rr="1JD","Joe Daly","other")))))

      That part...[b]if("RR"="1EM","Eric Menzer",[/b] ...does not work. All the rest work fine

      Even entered alone it fails.

      I have tried * and ? at end and changed the 1 for an L (lower case) and nothing will make it read that entry.

       

      Any ideas?