Less ten equal to not working in set

[Anonymous]

Hi geniuses,

I am using this formula

sum({$<Year = {$(=only(Year))}, [Fiscal Week ID] = {"<=$(=max([Fiscal Week ID]))"}>} [Product Bookings Net])

Fiscal Week ID is Numeric

But instead of giving all the data set which has Fiscal week ID less then the Fiscal Week I am selecting it jus give me the result whic is similar too

Sum([Product Bookings Net])

Has to present to client tomo

pls help

Thanks,

Shashank

[rajeshvaswani77]

You must chnage double quotes to single quotes.

thanks,

Rajesh Vaswani

[Anonymous]

If I am making selection on Fiscal Week Id it give me a correct answer but wen I make selection on Fiscal week it doesnot give me correct answer, though the Fiscal week Id And Fiscal week is linked

for exmple

if Fiscal week = wk1 Apr 2010

Fiscal week Id is=2010091

[CELAMBARASAN]

It looks like on selecting year also it will display data.

try with this

sum({$<Year = {$(=Max(Year))}, [Fiscal Week ID] = {"<=$(=max([Fiscal Week ID]))"}>} [Product Bookings Net])