IF greater than function returning 0

[Anonymous]

I am attempting to write the function below, I would like to divide the "Quality Hold" value by "Available to Allocate" value if "Available to Allocate" is greater than zero, if not then " ".  From this example it should calculate 41.4/541=.07652.  

In the example below the query results in 0.  Any thoughts?

[AlexisOlson · Accepted solution]

I think you want "> 0" not "< 0".

[HashamNiaz · Accepted solution]

Hi @Anonymous !

Please check you have put less than (<) operator in your equation. Once you replace it with (>) your query will be fixed.

Regards,

Hasham

[AlexisOlson · Accepted solution]

I think you want "> 0" not "< 0".