AnsweredAssumed Answered

Case Calculation with multiple fields.

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


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.