Case functions select the "result calculation" for the first expression that evaluates as true so you would need to modify the boolean expressions or their order inside the cas function to get the results that you want:
Case ( Not IsEmpty ( Line Items::Date_Merchandise_Received ) ; "Recieved" ;
Not IsEmpty ( Line Items::PO Number ) ; "Approved" ;
Not IsEmpty ( Line Items::Date_Requested ) ; "Requested"
) // case
Try to revert the order of the items:
Date_Merchandise_Received ; "Received" ;
PO Number ; "Approved" ;
Date_Requested ; "Requested" ;
So, my first error was not indicating that nothing is empty
and it looks like I needed to go backwards. The last test would be the first thing, which would be requested.
I am going to go ahead and make a date PO canceled field. I am thinking that the new entry should be after received, since the request will be and PO will be added before a cancelation.
worked using your formula Phil
Thanks for the heads up of order ray