
1. Re: How to calculate 0/0 and give 100%
Test Screen Name Oct 4, 2017 2:26 AM (in response to BergLino)0/0 is an error. It has no valid answer and you cannot change that. So just check your values FIRST and get the answer you want instead of dividing. Generally you should do this before any division calculation. Zero on top is fine, zero on the bottom is wrong.

2. Re: How to calculate 0/0 and give 100%
BergLino Oct 4, 2017 9:23 AM (in response to BergLino)I totally agree, but I use this in excel, and I use the = SE condition, where I say that if the division value is 0/0, it returns me 100%. This calculation is related to security actions encountered and security actions implemented. That would give me a percentage of implemented actions. But if I did not find any action to do, it means that everything is correct and therefore the performance of the performance is 100%. So I need the division by zero directs me to 100%. It would be as if I were ordering a condition, you see.

3. Re: How to calculate 0/0 and give 100%
try67 Oct 4, 2017 9:29 AM (in response to BergLino)You can do it like this:
var v1 = Number(this.getField("Box2").value); var v2 = Number(this.getField("Box1").value); if (v2==0) event.value = 1; else event.value = v1/v2;

4. Re: How to calculate 0/0 and give 100%
Test Screen Name Oct 4, 2017 10:09 AM (in response to BergLino)We have to work with the tools we have, each different. Excel might do this. JavaScript does not. Therefore you MUST use a condition, as shown.

5. Re: How to calculate 0/0 and give 100%
Test Screen Name Oct 4, 2017 11:03 AM (in response to BergLino)Actually I tried this in Excel if I divide one cell by another and they are both zero, the result shows "#DIV/0!". Even if I change the format to percentage.