4 Replies Latest reply: Sep 1, 2014 8:19 AM by PAUL YEO RSS

    Area chart get error msg on postive and negative value.

    PAUL YEO

      Hi All

       

       

      Below SET expression working fine in table .

       

       

      money(

      if([Exec P&L Level] = 's','',

       

       

      sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} Amount/1000/$(ColumnDim98))

       

       

      )

      , $(vMoneyFormatK_GL))

       

       

       

       

      when i convert to area chart , i get error msg :-

       

       

      Positive and negative value in chart.

       

       

      any solution ?

       

       

      Paul