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

How to replace null values?

Accepted answer


How to replace null values?

Content (required):

I’ve created an HCM Export and I have compensation fields like this:

I defined a replacement criteria on MSP_Element_Entry_Value field like so:

But if the system doesn’t find a value it simply returns nothing:

If the system finds values it works fine so the structure is correct. I think it may be some sort of bog. Anyway my goal is to have “0” in case of null values.

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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