I have written the below Validation Rule to check two values on an Opportunity record to ensure they equal each other in certain stages. However, during testing, it is confirmed that Users are suffering from being unable to save the record and hitting the error message even though the two values are identical. Can anyone assist? Thank you.
AND ((Total_Deal_Price__c <> Product_Roll_Up_Total__c), OR( ISPICKVAL (StageName, "5 - Negotiate"), ISPICKVAL (StageName, "6 - Contract"), ISPICKVAL (StageName, "7 - Closing"), ISPICKVAL (StageName, "Closed Won") )) && $User.Bypass_Workflows__c = false && ((RecordType.Name ="Products and Services") || (ISPICKVAL(Order_Sub_Type__c, "Contract Renewal")))