Case Calculation with multiple fields.
I currently have the following calculation that tells me from an Invoice layer whether or not a record appears in a linking table (our schedule). This field is called "OnShowdayField" (Showday being our schedule). Workorders is the linking table between the Invoices and the Showday Schedule.
Case ( WorkOrders::OnShowday; "On Showday"; WorkOrders::OnShowday="0"; "NOT ON SHOWDAY"; Invoice_Status="CANCELLED"; "CANCELLED"; "NOT ON SHOWDAY"; Rental_Type="SALES"; " ")
The problem I'm having with this calculation is that when something is marked as either Invoices::Rental_Type="SALES" " or Invoice_Status="CANCELLED," if I try to switch it back from Sales to Rental or from Cancelled to Final Invoice/Quote/Workorder,etc , it won't mark "OnShowdayField" as "On Showday" or "NOT ON SHOWDAY"
Any ideas? I was thinking it had to do with the fact that I'm referencing multiple fields in the Case calculation, but I'm not sure what the best way of fixing it is.