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



      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?