Skip to Content
0
Former Member
Aug 04, 2016 at 08:16 AM

Create YTD(Year TO Date) Variable in IDT 4.1 SP6

306 Views

Hello Gurus,

Stuck in to create a Variable in IDT for YTD to find Year to date value for a Measure .

Suppose I want how much Quantity ordered till date that will be entered like To Date will be prompted and from date will give date as per the selection of to date.

I have time_Key string value for date and measure value is Quantity.

And I want to create a variable for Year to date.

Note:- TO date will be any date like , 12 march 2015.(Not Current Date).

Please help me create a variable according to this scenario.

Backend DB is SqlServer.