Help with Formula-

[tstack]

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.

[jeff-allen]

Try adding the & to your Lookup function as well. This would apply safe navigation to both calls.

[rachelnatik]

I don't think you can have 2 "ELSE" statements. You would need to use a different formula such as elsif to carry this out.

[roland-daane]

Create a variable, and if datapil 1 is not present set it to 0.

Then use that variable in the formula.

On top of that keep a reference of the received null values and use that to update the source.

Get Outlook for iOS

[meghan-legaspi]

Hi Tracy Stack! Did any of these suggestions work for you?