2 Replies Latest reply: Jul 3, 2012 9:43 AM by Joe Kirwan RSS

    One value of dimension displays as Null (-) in Chart

    Joe Kirwan

      I am lading a field in my script as follows:

       

       

       

      if(len(Start)>0,(-((year(Order_Entry_Date)*12)+month(Order_Entry_Date)) + ((year(Start)*12)+month(Start))),Num(9999)) as

      Leadm

       

      It seems to work fine. My list box for the dimension displays as follows:

       

      Dim as Nill 1.PNG

      However, when I include Leadm as a dimension in a chart, the value 9999 is rendered as '-', as shown below

       

      Dim as Nill 2.PNG

      Any ideas?

       

      Rgds

       

      Joe