Syntax for comparing numeric plain text value with number value

Summary:

Requirement is to build analysis to identify employees whose payroll run result of a particular element does not match a corresponding value held in assignment dff.

Content (required):

Analysis is using Payroll - Payroll Run Results Real Time and Workforce Management - Worker Assignment Real Time

The payroll run result is a numeric value, but Column Properties show the default data format is Plain text

The corresponding value in assignment dff is numeric, with formula applied to round and return to 6 decimal places, and Column Properties show default data format is Number

The analysis, in its current state, returns both the payroll run result and the assignment dff in a visually identical format allowing easy manual comparison. However, the requirement is for the comparison to be handled by the analysis and only differences between the two values returned.