Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i am battling with the following statement
Sum({[Ar Vecka] = {" >=$( = max(År)-1 & week(max(Datum))) - VeckaAckSäsong)) <= $(=max(År)-1 & week(Max(Datum)))"}>}
Nettobelopp)
. i recieve no error message but still the value is shown as -
i would like state that VeckaAckSäsong is a number son in this case 12 which leaves we with the date 201444 - 12 = 201432 and the other date as 201444.
my goal is to find the interval between these two values.
any help is greatly appreciated .
Best
Brad
Hello,
If possible could you please attach a sample , so that i can dig into that.
Please replace the " >=$( = max(År)-1 & week(max(Datum))) - VeckaAckSäsong)) <= $(=max(År)-1 & week(Max(Datum)))"} " with the actual values and test it.
Thanks
i have attached a test
you will see the interval there 201332 - 201344. i have tried replacing the values without sucess.
Best
Brad