Did you copy and paste this expression or might you have accidentally made a mistake posting this expression?
Reformatting it to make it easier to read:
Case ( WorkOrders::OnShowday; "On Showday";
WorkOrders::OnShowday="0"; "NOT ON SHOWDAY";
"NOT ON SHOWDAY"; Rental_Type="SALES";
The text shown in red appears to be incorrect. The logical expression should come before the result returned if it is true and you seem to have them reversed.
What kind of field is OnShowDay? If it's a calculation field, what is its return type?
How does changing the invoice status field affect the value of WorkOrders::OnShowday?
How does Rental_Type change the value of WorkOrders::OnShowday?
Yeah, I copied and pasted it, sorry.
OnShowdayField is a Calculation field with Text return type.
Changing the invoice_status or Rental_Type doesn't have any effect on Workorders::OnShowday.
WorkOrders::OnShowday is a Calculation field returning a number with the following : not IsEmpty (WorkOrders::Invoice_ID)
Copy and paste is what you should have done. Your expression appears to have an error in it as I pointed out in my last post.
A case function evaluates from top to bottom and returns the value of the expression associated with the first expression to return true.
If: WorkOrders::OnShowday is True, then that value is returned and the results of any other logical expressions that come after it are ignored. Thus, if changes to invoice_status or to Rental_type doesn't change how this expression is evaluated, then those values will not affect the result returned by this case funcion
I'm also not sure that WorkOrders::OnShowday="0" will evaluate correctly. I'd use:
Please note that OnShowDay has only two possible values: True or False, thus, everything after the second logical expression will be ignored as one fo the first two expressions will always evaluate as true.