How to show 0?

[mithiladas02]

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.

[tackytechtom · Accepted solution]

Hi @mithiladas02 

How about this:

IF ( DIVIDE([A],[B]) <> 0, format(DIVIDE([A],[B]), "#,0") & ":1", "0" ) 

Does this work for you? 🙂

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

[mithiladas02]

Thank you, it's work for me.