7 Replies Latest reply: Dec 7, 2016 1:52 AM by Yeo Poh sai RSS

    After adding sales target 2017 data , now my SET expression if not select year=2016 , it display null value

    Yeo Poh sai

      Hi All

       

       

      My below expression work fine :-

       

       

      if(

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

      >=

      Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

      ,

      Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

      )

       

       

      Recently i have Add sales target table , which i add year = 2017 , Now my table have year =2017 , now my table alway display zero value. if user don't select any value on year.

       

       

      Since now is still Dec 2016 , all my expression unable to work well , and user need to select year=2016 , then it can work. As system

      take max year = 2017.

       

       

      May i know any solution ?

       

       

       

       

      Paul