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