Forum Discussion
Solved
How 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
Hi mithiladas02
How about this:
IF ( DIVIDE([A],[B]) <> 0, format(DIVIDE([A],[B]), "#,0") & ":1", "0" )
Does this work for you? 🙂
/Tom
Thank you, it's work for me.
