Forum Discussion
mithiladas02
Helper I
Helper IHow to show 0?
Hi, Here is my syntex- format(DIVIDE([A],[B]), "#,0") & ":1" above this syntex i am getting value 10:1. there are many rows, value is zero and the syntex is giving results like 0:1. i want t...
Hi mithiladas02
How about this:IF ( DIVIDE([A],[B]) <> 0, format(DIVIDE([A],[B]), "#,0") & ":1", "0" )
Does this work for you? 🙂
/Tom
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi mithiladas02
How about this:
IF ( DIVIDE([A],[B]) <> 0, format(DIVIDE([A],[B]), "#,0") & ":1", "0" )
Does this work for you? 🙂
/Tom
mithiladas02Helper I
Helper IThank you, it's work for me.