Hi Infinity team,
I’m trying to set up a metrics table for tracking my goals. I have three integer fields, “StartValue”, “CurrentValue” and “GoalValue”. None of them are empty or zero. However, when I want to create a formula for tracking the progress “CurrentValue/(GoalValue-StartValue)” it says “can’t divide by zero”. I tried it also with DIVIDE and MINUS functions instead of / and - but didn’t help. By the way, the result was set up to b shown as a percentage but I tried other result formats as well but it didn’t seem to have anything to do with the eerror popping up. If I left the brackets away (which made the result incorrect of course), the error no longer appeared, so my think it may be something up with them. Again - none of my data values were 0 or empty. I had only one row where StartValue = 15, CurrentValue=40 and GoalValue=250, no commas, no negatives or anything else that could mess this up.
Thands in advance for looking into this,