Forum Discussion
Infinity values due to division
Hello, I am getting many infinity values in my data set with the following formula. I believe that it is because it is dividing by 0 and not knowing NOT to divide by 0.
Inspection Cost per Mile = IF(NOT(ISBLANK([Length Miles])),[Inspection Total]/[Length Miles],BLANK())
1 Reply
mn75224 Use the DIVIDE function as it is designed to handle things like this.
