6 Replies Latest reply: Jun 25, 2015 10:10 PM by Michael Solomovich RSS

    Creating a variable for expression (not working)

    Steve Zagzebski

      I am trying to create variables for all my commonly used expressions. This is just one example below:

       

      Let vFSRevMaxYear = 'Sum({$<[GL Dashboard]={'Revenue'},[Entity Location]={'01-WC,'03-EC'},Calendar_Year={$(=Max(Calendar_Year))}>} [Amount GL])*-1';

       

      This expression doesn't work as I keep getting a "script line error"  - is it because of dashes or apostrophes? If so what is the best solution?

       

      Thanks in advance,

       

      Steve