cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Help with Formula-

tstack
Deputy Chef I
Deputy Chef I

Hello! I'm struggling with an error in one of my formulas 'Formula received a nil value: undefined method `+' for nil:NilClass' After doing some research, I was thinking that using "&" for safe navigation, but still getting the above error.


This is the formula that I am using:

[DATAPILL1]&.presence ? lookup("TABLE_NAME", "FIELD_NAME": [DATAPILL2) ["FIELD_NAME"]+[DATAPILL2]: [DATAPILL3]


the Datapill1 that I'm using to look for the Lookup Table, comes in blank or null every once in awhile. In that case, I want to populate it with Datapill3. However, I am receiving the error rather than the data being replaced with Datapill3 which should be the second condition. Any advise would be great.

10 REPLIES 10

nikhitha-thatra
Deputy Chef I
Deputy Chef I

Let me know if it works & satisfies your usecase or not.