18 Replies Latest reply: Jan 5, 2011 12:11 PM by Oleg Troyansky RSS

    Max(Year) is not working in my expression

      Hi All,

      I want to pass the Max(Year) dynamically instead of statically(START_YEAR='2010' ). Any idea how to do the same?

      I tried to pass $<START_YEAR={$(=Max(START_YEAR))}>} instead of START_YEAR='2010' but it didn't work. Please help me out



      =ceil(sum(if( START_YEAR='2010' and wildmatch(Category,'*Call1*') > 0 and (wildmatch([Agreement Met],'no')>0),1,0)) /
      sum(if(START_YEAR='2010' and wildmatch(Category,'*Call1*') > 0 ,1,0)) ,.01)