3 Replies Latest reply: Jun 17, 2016 7:35 PM by PAUL YEO RSS

    How to dynamic change the 365 days if now is June , it change to 180 (30*6)Hi All

    PAUL YEO

      Hi All

       

      I have a Table only Row one display wrong value.

       

      The rest of the Row display correct value because my dimension is year , and it allow multiply by 365.

       

      My first row YTD only 5 month , it should be 30*6=180 day not 365 days.

       

      May i know how to make use of script to dynamic change the days ?

       

      I expected to get 28.8 . ( 0.16 * 30 * 6 )

       

      Now it display 58 ( 0.15 * 365 )

       

      Paul