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!