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