current week set analysis syntax.

Tue, 20 Aug 2013 19:13:12 GMT

hi currently i have an date field which stretches my weeks association above current week,

i.e this week is week 33, my field week has assocations to week 54.

what i am looking to do is create a set analysis statement using the current week.

i have tried the following without success;

Sum({$<Week(today(Week=>},Nettobelopp)/1000)

in normal case of course you can use max(Week) however in my case not.

Sum({$<Week={$(=Max(Week))}>} Nettobelopp)/1000

any help is greatly appreciated.

Best,

Brad

Re: current week set analysis syntax.

Oleg_Troyansky — Tue, 20 Aug 2013 22:57:33 GMT

How about this:

Sum({$<Week={$(=Week(Today()))}>} Nettobelopp)/1000

or, if you can pre-calculate the current week as a variable in the load script, you could use the variable:

Sum({$<Week={$(vCurrentWeek)}>} Nettobelopp)/1000