Syntax for comparing numeric plain text value with number value
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.
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.