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 to know how can i write the syntex that when i get 0 result will show 0 not 0:1.
Thanks in advance.
Hi mithiladas02
How about this:IF ( DIVIDE([A],[B]) <> 0, format(DIVIDE([A],[B]), "#,0") & ":1", "0" )
Does this work for you? 🙂
/Tom
2 Replies
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.
