Forum Discussion
Solved
New column calculation - Infinity
I added a new column and created a formula to convert my sales figures to functional currency. All similar data could be calculated normally but some comparable data are showing infinity. They have t...
carmenchong , can you share calculation.
Also, use divide to avoid divide by 0
Divide([Col1],[Col2])
Hi, carmenchong
As amitchandak said, the divide function can be used.
The reason why infinity is shown is that there are some values that are 0. 0 divided by a number is infinity. You can use the divide function to avoid infinity because the function can get 0 when it encounters a value of 0. Or you can make a conditional judgment, for example a/b, if a is 0 then get 0, otherwise a/b.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.