Please Follow the below scenario:
There is period column. User Wants that 01 from 2016001 should be converted in Apr and so on but last number as mentioned above that are 13, 14, 15 should be converted in March only.
And on that basis wants the calendar should be started from April only.
I used below mentioned script but sales not coming correct . Please Help me
if(right(Period,2)>=12,12,right(Period,2)) as Periods,
(ooxml, embedded labels, table is Sheet1);
Load Sales,Date(MakeDate(left(Period,4),Periods),'DD/MM/YYYY') as MD
Please help me.
I think you should connect your period-field with a normal master-calendar and a fiscal-calendar and/or using an As-Of-Table. Here you will find many informations and examples about: How to use - Master-Calendar and Date-Values.