โ07-08-2022 06:05 PM
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.
โ07-08-2022 06:44 PM
Try adding the & to your Lookup function as well. This would apply safe navigation to both calls.
โ07-08-2022 10:27 PM
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.
โ07-09-2022 12:59 PM
โ07-11-2022 12:05 PM
Hi Tracy Stack! Did any of these suggestions work for you?