8 Replies Latest reply: Sep 26, 2014 5:25 PM by Marco Wedel RSS

    How to reference a value in line y of the script that was defined in line x of the script?

      In the code below, I define [Days_Open] on the first line and want to reference it in the second line. My reload says the [Days_Open] field cannot be found.


      Anyone know what's going on? How can I fix this?



      Interval(Today()-[Entry Date],'d') as [Days_Open],

      If([Days_Open]<=30,'0-30 Days','>30 Days') as [Days_Group]