Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
StacyCui
Creator
Creator

Number format

Hi,  I have three number. When I use PY Potential -(Competitor Volume+PYOR),  it shows 7.11f,   Why it doesn't show 0?  For the script, I convert the number into decimal and then sum, Does it influence the results?

StacyCui_0-1679291567548.png

StacyCui_1-1679291643876.png

 

Labels (2)
1 Solution

Accepted Solutions
StacyCui
Creator
Creator
Author

I have solved this issues, Multiple  100 and then use round() . Thank you so much for your reply.

View solution in original post

3 Replies
BrunPierre
Master
Master

Hello, if possible, can you share sample data and expected output?

Vegar
MVP
MVP

7.11f is the ISO notation for the small number 0.00000000000000711. 

Try wrap a Round () around your expression or format the output with desired numbers of decimal.

StacyCui
Creator
Creator
Author

I have solved this issues, Multiple  100 and then use round() . Thank you so much for your reply.