Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the Time dimension criteria, Is there any option like YTD? How to achieve it?
Regards,
Jeeva.
Perumal,
I can't see your file. Its telling "No Data to Display" & "Allocated Memory Exceeded". What shall i do for this?
Regards,
Jeeva.
Chriscammers,
Yeah, Thanks.
Regards,
Jeeva.
Hi,
I got one application where YTD has been defined if it is useful ok
// below code will create last x year YTD sales.
Let vMonthNow = Num(MakeDate(Year(Today(1)), Month(Today(1)), 1));
Let vMonthNowLY = Num(MakeDate(Year(Today(1))-1, Month(Today(1)), 1));
Let vMonthNowL2Y = Num(MakeDate(Year(Today(1))-2, Month(Today(1)), 1));
Let vMonthNowL3Y = Num(MakeDate(Year(Today(1))-3, Month(Today(1)), 1));
Let vMonthNowL4Y = Num(MakeDate(Year(Today(1))-4, Month(Today(1)), 1));
Let vMonthNowL5Y = Num(MakeDate(Year(Today(1))-5, Month(Today(1)), 1));
Let vMonthNowL6Y = Num(MakeDate(Year(Today(1))-6, Month(Today(1)), 1));
Let vMonthNowL7Y = Num(MakeDate(Year(Today(1))-7, Month(Today(1)), 1));
chriscammers,
How will u achieve fiscal ytd and cal ytd. Can u explain me?
Regards,
Jeeva.
Hi,
I am sending u a file in that he has defined YTD if it is helpful k
Regards,
Rathish