Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MTD Caculation Problem

My requirement is to sow the measure value for MTD.

For example if user selects a Date 20/01/2014 i need to sow the measure value from 01/01/2014 to 20/01/2014.

I am trying to calculate MTD for my measure using below formula



    CASE WHEN (SomeTable.Fact_Date) between TRUNC (@prompt(Date) , 'mm') and @prompt(Date)

       THEN FactTable.Measure



am writing this formula in select clause of measure object in IDT.

but its throwing below error.

[Microsoft SQL Server Native Client 10.0] : 'TRUNC' is not a recognized built-in function name.

Can anyone pls help me how to achieve MTD calculation in detail.



Not what you were looking for? View more on this topic or Ask a question