Grid null or zero or blank

I have a grid summery - but i have fields with blank - null values. How can i tel them to take the nearest field with a value and use that value

Can you trap the “last” value in the onRecord event, and using an IF statement, set the Null to that value?

This won’t work if the first one is Null however.