Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Recently, I want to calculate PY Potential-(PY OR + Competitor Volume) as below. But I want to get result is 0 rather then -7.1f. because I want to know if the result is greater than 0 or not. How to change the number format?
And if you try with :
num(PY Potential-(PY OR + Competitor Volume) ,'# ##0')
But ,if I use this formula and then when PYPotential = 0,PYOR = 0.67, CompetitorOR = 0, the result will be 0.00. It is not right.