4 Replies Latest reply: Feb 17, 2017 1:15 AM by Shraddha Gajare RSS

    Problem with Set analysis date testing

    Adil Marhi

      Hello everyone,

      did someone can translate this simple sql query to a set analysis expression :

      Select sum (amount) from table1

      where date1 <= date2

      and code in ("AA", "BB", "CC") group by Id

      we have already test this expression :

      =Sum({<code= {"AA", "BB", "CC"},, Date1 = {$("<=(Date2")}>}(amount))

      But the returned result is always null

      Thank you