Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies