6 Replies Latest reply: Apr 30, 2014 10:42 AM by Steve Dillon RSS

    Expression to calculate revenue invoiced for today

    Steve Dillon

      I've written an expression to calculate revenue invoiced today using a variable but I can't seem to get the syntax correct. I keep getting error in set modifier ad hoc element list: ',' or ')' expected.

       

      Here is my expression:

       

      =Money(sum({<TRANDATE={$=vToday},TRANSACTION_ORDER={'0'}>}AMOUNT))