Divide by what? 2? What's the name of the field that contains the sub-total you want to divide?
Field Name "Cash Availability" divided by "Cash Needs for 30 Days".
Use this code as the custom calculation script:
var v1 = Number(this.getField("Cash Availability").valueAsString);
var v2 = Number(this.getField("Cash Needs for 30 Days").valueAsString);
if (v2==0) event.value = "";
else event.value = v1/v2;
Thank you so very much!!! You saved me!
Write this in "Simplified Field Notation": Cash\ Availability/CashNeedsFor30Days
Unfortunately, this one wouldn't work for me. I don't understand why, but it wouldn't divide the fields. The above custom calculation script did the trick though. Thank you for reaching out - greatly appreciated!!
Thats because I thought your field name is "CashNeedsFor30Days" but it's "Cash Needs for 30 Days"
the code should be: Cash\ Availability/Cash\ Needs\ for\ 30\ Days
It's better not to use spaces in field names if using SFN.