YTD Error

[damzi]

Hi Friends - I need some urgent help with this. The YTD calculation I have used in the FrameWork Manager to use is my reports is as below,
total(If(year( [SanfordDW].[Date].[Date] )=year(current_date)
and [SanfordDW].[Date].[Date] <= current_date)
then ([SanfordDW].[POSMonthly].[QtySold] ) else (0))
This does not help me with the YTD rollup values as expected. Thnx!

 

[DoubleD]

damzi,
I don't understand your question. Your calculation appears to provide a YTD Total. What isn't it doing that you need it to do? Please give an example.

I am what I am based on the decisions I have made.

DoubleD