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

    Help with using functions within an expression

    Chris Walsh



      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