Skip to main content
jonathanm75257324
Known Participant
September 24, 2018
Question

Error Message when calculting growth percentage

  • September 24, 2018
  • 3 replies
  • 485 views

I was able to get the formula to work using the simplified notation calculator, but it was giving me the format error message.

Per my code below, I am trying to calculate ((V1+V2)/V1) -1. But it is not calculating anything. Please help!

var v1 = Number(this.getField("Original_Line_Amount)").valueAsString); 

var v2 = Number(this.getField("Overage_Amount").valueAsString); 

if (v2==0) event.value = ""; 

else event.value = (v1+v2/v1) - ; 

Thanks!

This topic has been closed for replies.

3 replies

try67
Community Expert
Community Expert
September 24, 2018

Change the last two lines to:

if (v1==0) event.value = ""; 

else event.value = ((v1+v2)/v1) - 1; 

Bernd Alheit
Community Expert
Community Expert
September 24, 2018

You must test v1 for zero.

Inspiring
September 24, 2018

JavaScript cannot divide by xero

Inspiring
September 24, 2018

gkaiseril  wrote

JavaScript cannot divide by xero

Sure it can, without exception.

jonathanm75257324
Known Participant
September 24, 2018

George, could you please explain with some code?