solution
  • Call Us
  • 360.322.4907 or 610.562.2900

Monday - Friday ( 10.00 - 17.00 EST / 07.00 - 14.00 PST )

Can I change NaN to Something Else?

"NaN" or Not a Number is generally a result of an invalid equation. i.e. You are trying to divide a number by 0.

The way the math script works, if you leave a field blank, for the user to enter a value it will initially view that field as having no value and will use 0 on page load which results in a NaN result.

If you want to replace that value with something else you can easily do so by adding this to the end of your formula in the results field:

|| 0

Example:(field1 / field2) || 0

  • Friday, 21 July 2017

Support is currently

Support Forum

Announcements
  1. 0 subcategories
CiviCRM for RSForm
  1. 2 subcategories
NS Members Only
  1. 2 subcategories
NS Formula
  1. 2 subcategories
Marysville, WA 98270 United States
(360) 322-4907
Hamburg, PA 19526 United States
(610) 562-2900

Newsletter

Keep up-to-date with our latest news.