Formula Help: Handling 'NULL' in Currency Field Without Circular Reference

System

This discussion was created from comments split from: Replacing NULL in a column with zero.

SueinSpain

I have a similar problem but…. it is a currency field

I have tried =If([Buying Price]@row = "NULL", "£0.00", [Buying Price]@row)

but it just says #circular reference

any further ideas team?

Paul Newcome

@SueinSpain Try a change cell automation to just output 0 when the value is "NULL".