What's new in Customer Journeys?

Connect and learn more!
Syntax for comparing numeric plain text value with number value — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Syntax for comparing numeric plain text value with number value

Received Response
edited Jan 31, 2023 4:01PM in Reporting and Analytics for HCM 1 comment


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.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!