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

    Problems with zeros in value for Expression



      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:



      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)