Fix Calculated Formulas

if your swimlane instance throws 500 errors when you click on records or when you try to open an application, you might pull errors similar to this more than likely, this error means you have calculated fields that are not failing because they aren't accounting for empty fields for example, you have a calculated field, case tt resolved min whose calculations depend on case created on and case closed on fields you will get an error if those two files are not populated correctly chances are these fields are using a formula similar to the following if (\[case created on] = \[case resolved on], 0, totalminutes(\[case created on],\[case resolved on])) notice that this formula is only checking if two fields are equal in order to skip the calculation and return 0 however, it is not checking whether case created on or case resolved on fields are empty the fact that these fields are indeed empty is likely causing the issue to confirm if this is the issue, open the problematic record(s) and check if all the fields are populated if they are not, you have found the problem! to fix this issue from the swimlane global navigation menu, select applications & applets select the application or applet that is causing the error select the fields in the form layout and select edit to open the calculation builder change the formula by adding “or” and “isblank" to allow for the empty fields, for example if (or(\[case created on] = \[case closed on], isblank(\[case created on]), isblank(\[case closed on])), 0, totalminutes(\[case created on],\[case closed on]))