I'm having an issue with the following Validation rule, the issue only arose yesterday for the first time. The rule is as follows:
AND( ISPICKVAL(Sync_to_Sage__c, 'Ready to Sync'), Total_Amount__c != Labour_Net_Amount__c + Parts_Net_Amount__c )
The issue is that the validation rule is being set off even though the total amount is equal to the labour + Parts amount
I've queried the results of total amount, Labour net amount and Parts net amount in the Dev Console and the three results are adding up correctly. All three fields are Roll up summary fields.
Does anyone have any suggestions for what may be causing this?