2 Replies Latest reply: Apr 12, 2018 2:59 AM by Andrei Kaliahin RSS

    Complicated Set analysis

    Louis Lam

      Hi All,

       

      I would like to have an set analysis with below criteria:


      Startdate <= “20170101”

      And (ClosedDate = ‘'19000101' or ClosedDate >= “20170101” )

      And (T2Startdate2>= 20170101  and T2Startdate2 <='99991231') )


      I make an expression as below but it is wrong...

      Sum({$<Startdate ={"<20170101"},T2TransDate ={">20170101"} ,ClosedDate={"01/01/1900>=20170101"}>}  Amount)

       

      Any idea on it?

       

      Best Regards,

      Louis