5 Replies Latest reply: Feb 1, 2016 4:36 AM by Stefan Wühl RSS

    Help with using functions within an expression

    Chris Walsh

      Hi,

       

      I wondered if someone can help with the below function.

       

      =sum({<[WeekPeriod] ={<=$(Year(today())&num(week(Today())+1,'00'))}>}[Value To Make])

       

       

      I have a field called WeekPeriod which is name up of Year and Week number e.g. 2001604 is year 2016 week 04

       

      I also have a “Value to make” column which contains values I want to sum up.

       

      What I’m trying to do is sum up all values in “Value To Make” which are before this week (less than 201604)

       

      I can’t seem to get the logic correct though.

       

      Any help would be appreciated


      Cheers

      Chris