4 Replies Latest reply: Aug 31, 2012 5:02 PM by Richard Lowe RSS

    Easy Sum with Variable Question

      As part of this trying to convert an end user entered Date (on a calendar element) inside the expression, in a normal "If" statement it works fine as Date(vDateEntered) to converts successfully from number to date format. 

       

      Sample:    =Sum(If(SalesDate=Date(vDateEntered), Sales)) works perfectly.

       

      But converting this example to set analysis isn't converting to date mm/dd/yyyy format correctly.

       

      =sum({<SalesDate={'=Date$(vDateEntered)}>} Sales) 

       

      (just summing up sales for whatever date a person picked)

       

      Can you tell me the right syntax for this?   Thanks much!