Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
I think you want "> 0" not "< 0".
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |