Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thankyou !!!!!!!
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
This didn;t work 😞 but thanks for trying
sorted thanks - changed to num in the script !