Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community,
I am looking to find the minimum value of a date field called transaction_date where stock (an other field) is not null.
How can I achieve that?
Best regards,
Abdallah
Try like...
Min({ $-<[Stock]={'*'}>}transaction_date)
Maybe sthing like :
date(min (total {<Stock={"=len(trim(Stock))>0"}>} Transaction_Date))
May be this
Min({<stock = {"*"}>}transaction_date)
Hi,
This expression returned dash(-) only not the minimum date where stock <> 0.
Best regards,
Abdallah
May be this?
Min({<stock = {"<>0"}>}transaction_date)