Skip to Content
0
Apr 16, 2010 at 04:08 AM

Calculation of YTD Pre Year and YTD FULL Pre Year

81 Views

Hello Experts,

We have requirement to calculate the Sales values with columns YTD previous Fiscal Year(FYear) and YTD FULL Previous FYear.

I caculated as below

YTD Pre FYear

- Sales

- FYear (restricted with current FYear variable and taken offset -1)

- FWeek (we have defined Fiscal Week variables which will calculate YTD using FWeek)

YTD FULL Pre FYear

- Sales

- FYear (restricted with current FYear variable and taken offset -1)

But when i run the report, the 2 columns are showing same values.

Can anyone tell me how to differenciate YTD and YTD FULL? give me idea how to calculate and why I am getting same values?

Thanks,

Venky