I am using Retool and trying to populate a calculated column with the script below, which works, except all null values are ignored and return null. I would like to return any values not found as 0 instead.
{{virCount.data.find(x=>x['Employee Name'] === currentRow['Name'])['Days Completed']}}
I have tried to follow this previous question: (Javascript, assign value from .find or else 0) to no avail.
Any help is greatly appreciated. Thank you!