AnsweredAssumed Answered

Case Calculation with multiple fields.

Question asked by BERGSTEN on Mar 19, 2012
Latest reply on Mar 19, 2012 by philmodjunk

Title

Case Calculation with multiple fields.

Post

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.

Outcomes