If statement and set analysis

[renjithpl]

Hi All,

I have an expression like below

if(

Dim_FY_New = vNYear, 0,

rangesum(above(SUM({<Dim_FY_New = {'$(vCYear)'}>} S_Amount_USD)),0,RowNo()))

I want to restrict the rangesum formula to Current Year which is 2016.

Please see the attachment as per my above formula. Why doesnt it restrict to 2016 quarters.

Appreciate your response.

Thanks

Renji

[renjithpl]

This is exactly i want.

Thanks Anil.