Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am working on ytd,mtd calcuation in script level.
Below is my script.
I am getting the day values which are correct .But my ytd ,mtd are wrong values.Please correct if my formula is wrong.
Load *, 'YTD' as TimeGranule
Resident Cal where Date >=YearStart(TempDate) and Date<=TempDate;
Load *, 'MTD' as TimeGranule
Resident Cal where Date >= MonthStart(TempDate) and Date <= TempDate;
Load * , 'Day' as TimeGranule
Resident Cal
where Date=TempDate;
Thanks
Have a look here: