8 Replies Latest reply: Nov 24, 2012 4:17 PM by Jan Verduin RSS

    Problems with zeros in value for Expression

      Hello,

       

      I'm dying for some help with an expression I've written in a chart. The field has mixed values, some are only numbers and others also contain a letter in the beginning. Like this:

      500020

      D345737

      But there is one value that is causing me headaches; D000158. I want to eliminate that value but it simply will not work!

       

      The expression is:

       

       

      if(Orderklantnummer=('D000158'),Null(), Sum({$<OrderJaar={$(=Only(OrderJaar))}>}Bedrag))

       

      If I use the value 500020 or D345737 here it works oke, but as soon as I put the value I need in nothing happens.

       

      Hope someone can illuminate me here because I have just been starting to work with QV (11)