1 Reply Latest reply: Aug 20, 2013 6:57 PM by Oleg Troyansky RSS

    current week set analysis syntax.

    Bradley Coyne

      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