3 Replies Latest reply: Jun 27, 2016 10:45 PM by Settu Periyasamy RSS

    Why need to compute by if XXX >1,1 then compute the sales / target ?

    PAUL YEO

      Hi All

       

       

      Recently i notice that some of the QV expert when they try to compute sales vs target , i notice they alway use the below expression :-

       

       

      (if((

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

      /

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

      )

      >1,1,

      (

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

      /

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

      )))

       

       

      All the while i am using below appraoch :-

       

       

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

      /

      sum({$<year = {$(=max(year)-0)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}sales_target/Rate/1000)

       

       

      I Do notice the different of above 2 expression , mine is able to see the sales vs target actual % , but the first appraoch is stop at 100%.

       

       

      May i know in what situation need to apply if ?

       

       

      Paul