Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
StacyCui
Creator
Creator

Number Format

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?

StacyCui_1-1681281909411.png

 

 

Labels (2)
2 Replies
sergio0592
Specialist III
Specialist III

And if you try with :

 

num(PY Potential-(PY OR + Competitor Volume)  ,'# ##0')

 

StacyCui
Creator
Creator
Author

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.