Help with this formula Please

[Get_Involved]

In this formula If the [[#Totals],[BALANCE]] is $0.00, how would I write this formula not to show the 0.00’s?

CheckRegister78910161836[[#Totals],[BALANCE]]

Thanks in advance

 

[Tom.Jones]

You can use Conditional formatting or custom number to prevent that 0 (zero)


Or

=IF(CheckRegister78910161836[[#Totals],[BALANCE]]=0,"",CheckRegister78910161836[[#Totals],[BALANCE]])