Skip to Content
0
Former Member
Apr 23, 2014 at 10:07 AM

MTD based on Date Characterisitics

42 Views

Hi Team,

We got two date characteristics i.e. Teco date and Labour date, based on the “Service order”.

We need to calculate MTD (actual and Prior year) by applying with this logic.

The calculation of MTD should be based on the Last TECO Date (Input Variable).

For example i.e. if I enter older date/month (not current date) [1/20/2014 means it should calculate for 1/1/2014 – 1/31/2014]

If the Input variable is current month’s date, then the MTD calculation should be = 1st day of month – Current Day.

For the above MTD calculation; we need to fetch the relevant Service orders and use it in the below final calculation.

The above same calculation logic should be applicable for MTD actual and prior year:

We don’t have any other Key figures involved except these date characteristics.

Final Calculation:

If Last Labour Date is blank, 0, else Last TECO Date – Last Labour Date (by individual line item).

Can anyone help me how to achieve this requirement?


Thanks

San