Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This is exactly i want.
Thanks Anil.