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]