Hi,
I have to calculate a MTD and YTD Keyfigure. The user will select a Year and according to that the MTD and YTD KPIs are shown. The Month will always be the current month and Date will always be Current Date.
So the Calculation logic will be:
MTD: For the selected Year - Data for Current Month till Current Date
YTD: For the selected Year - Data from January 1st till Current Month and Current Date
I guess we need to create a formula with some programming logic. Also i come across function like MonthToDate and YearToDate. Any idea if they can be used?