Forum Discussion
IF greater than function returning 0
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?
I think you want "> 0" not "< 0".
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
2 Replies
I think you want "> 0" not "< 0".
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