How can I safely handle cases where GET_VALUE_SET returns null, and default the value to 0 — 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

How can I safely handle cases where GET_VALUE_SET returns null, and default the value to 0

Summary:

When the value set returns null (i.e., no leave has been taken), the formula either fails or doesn't return the expected accrual. Even though I am checking for ISNULL(L_LEAVES) = 'Y', the behavior is inconsistent.

I'm working on a Fast Formula that uses a value set (PRE_ANNUAL_BALANCE_VS) to return the number of leaves taken by an employee so far. The value set works correctly when there are records, but when no leave has been taken yet, it returns nothing (NULL), and the Fast Formula does not behave as expected.

I’ve added logging and observed that when

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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