YTD calulation

[Karim_Khan]

Hi Team,

    I want YTD calculation on the basis of Monthly selection

[Karim_Khan]

No Sir,Its not working I have the Fiscal Period ID only

[MK_QSL]

Provide your sample qvw please

[MK_QSL]

While Loading data in script define FiscalPeriodID as below

Date#(FiscalPeriodID,'YYYYMM') as FiscalPeriodID

Now use the same which I have provided...

[Karim_Khan]

But I already have field with the same name won't it give an error

[MK_QSL]

FiscalPeriodID need to be used only once, so use only this...

Date#(FiscalPeriodID,'YYYYMM') as FiscalPeriodID

[Karim_Khan]

[MK_QSL]

It should be

[Fiscal Period ID]

[Karim_Khan]

sorry

[Karim_Khan]