Forum Discussion

carmenchong's avatar
carmenchong
New Member
5 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    carmenchong , can you share calculation.

     

    Also, use divide to avoid divide by 0

     

    Divide([Col1],[Col2])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

carmenchong , can you share calculation.

 

Also, use divide to avoid divide by 0

 

Divide([Col1],[Col2])