YTD RangeSum - Need help with Set Analysis

[bmicqlik]

I am trying to create a cumulative YTD total by month and this code works great and producing the right numbers:

RangeSum ((Above(Total [vEarned])), sum(if (InYeartoDate ( [Full_Date], vMonthEnd, 0) ), [earned], 0)),0)

I really do not want the previous months' to show up here and I think I need set analysis but cannot figure out the syntax. 

Can anyone help  ?    I want the set analysis to work like the Inyeartodate function ........

Thanks in advance !!

[jonathandienst]

Hi

Assuming the MonthName column is a dimension, could you not just suppress zeroes in your table?

Regards

Jonathan

[bmicqlik]

It is and zeroes are suppressed yet it still shows this way.

Sent from my iPhone

[jonathandienst]

What other columns (expressiosn) in your table.

Might be easier to check if you post your model or a sample illustrating the problem.

Regards

Jonathan

[bmicqlik]

This expression works, except it repeats the

This year:

rangesum((Above([VEarned_TY])),sum({$<Year={$(=Max(Year))

Last year:

rangesum((Above([vIncurred_LY])),sum({$<Year={$(=Max(Year)-1)

BUT my dimension is month and the last month of this year repeats the last value when there is no  value to display.....