0 Replies Latest reply: Jan 29, 2018 6:28 AM by Sofia Vaz RSS

    Variable not working

    Sofia Vaz

      Hi all,

       

      I have a variable (vLastInsDtWeek) with this expression:

       

      if(weekday(max(OrdItemInsDt))='sex',max({<OrdItemInsDt={*},OrdItemInsDtYear={'$(=vCurrentInsDtYear)'}>}OrdItemInsDtWeek), max({<OrdItemInsDt={*},OrdItemInsDtYear={'$(=vCurrentInsDtYear)'}>}OrdItemInsDtWeek)-1)

       

      The expression works fine alone, in a text and image box and when I insert it "directely" in another expression. But, in this other expression, when I try ti use the variable name, OrdItemInsDtWeek={'$(=vLastInsDtWeek)'}, it doesn't work!

       

      Do you have any idea what I might be doing wrong?

       

      Thank you!