Skip to Content
0
Former Member
Nov 28, 2011 at 07:31 AM

Calculation logic for MTD and YTD KPIs

310 Views

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?