3 Replies Latest reply: Jun 21, 2012 11:11 AM by Dan Turner RSS

    Rolling date range in set analysis expression

      I am trying to create a set analysis expression that will select transactions that have date from today to three days ago. This is the expressionL

       

      (Sum ({<nDate = {"$((>=num(today())-1))"}>}[Actual Input Qty]))-(Sum ({<nDate = {"$((>=num(today())-1))"}>}[Std Input Qty])) 

       

      This expression returns zero for all instances.  I would appreciate any help you can provide.