Strangely simple sum not working

[#1]

HI,

I cannot get what should be a really simple sum to work. In the attached you will see a simple branch, week, budget table.

Using a variable 'thisweek' I am just trying to get sum to show if WEEK = thisweek sum the budget, but it is not working.

Am I missing something obvious please as this is driving me nuts !

Thanks in advance

Nick

[#2]

Thankyou !!!!!!!

[#3]

HI All,

As a follow on, I cannot seem to get this to work with multiple weeks though... the below does not seem to work

((Sum({$<WEEK={"(=Num#(WEEK) >=$(StartWeek) <=(ThisWeek)) "}>} Budget)))

does anone have any ideas  please?

Thanks again

Bob

[#4]

This didn;t work 😞 but thanks for trying

[#5]

sorted thanks - changed to num in the script !