0 Replies Latest reply: Aug 1, 2013 6:13 AM by Wiwin Then RSS

    Calculate YTD to MTD in script

      Hi,

       

      I need your help. I have YTD data. I want to create MTD from YTD. Can I do that?

      I want the data processed in script, not in expression. After this finished, expressions are much easier. And I'm stuck hehehe...

      I attached the qvw in here.

      Please kindly your help.

      Note: the "Date" column is in month data. 1/1/2012 means jan 1, 2012. 2/1/2012 means feb 1, 2012. This BI is for our group, that's why we have more than 1 company in this sample.

       

      Thanks & Regards,

      Wiwin