Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hallo Louis,
I think this should work:
SUM({<Startdate={"<=20170101"},CloseDate={">=20170101", "19000101"},T2Startdate2={">=20170101<='99991231'"}>}Amount)
Best Wishes
Stefan
Hallo Louis,
I think this should work:
SUM({<Startdate={"<=20170101"},CloseDate={">=20170101", "19000101"},T2Startdate2={">=20170101<='99991231'"}>}Amount)
Best Wishes
Stefan
Hi Louis,
Try below (giving everything is numbers and no need to format anything):
Sum( {<Startdate ={"<=20170101"}, ClosedDate ={">=20170101", "19000101"}, T2Startdate2={">=20170101<=99991231"}>} Amount)
Hope this helps.
//Andrei