Copy link to clipboard
Copied
I can't figure out why my custom calculation isn't updating...? If I go from left to right then the custom calculations work fine but if I bounce in between cells onthe paper then the % of inventory stops updating... as you can see here I went back and deleted the middle room pool group number (which was 5) but the percent remained 45....? Any help? I've read about setting the calculation order but what if you bounce around on the paper? How can I get it to always recalculate....Thanks in advance!
Thank you so much!!! That fixed it!! 🙂 -- One last question...I'm getting this error .. any advise on fixing that? I didn't change the format form before and this is the first time I am getting this error.
You are missing an "else" in "INVENTORY OFFERED" field script.
if (v2==0) event.value = "";
else
event.value = v1/v2;
Copy link to clipboard
Copied
Check the calculation order. The calculation order is completely independent of the order of entered data. So it doesn't matter if you skip around.
If that's not the issue, then there may be an error causing the issue. Look in the Console window to see if there are any messages.
Copy link to clipboard
Copied
Copy link to clipboard
Copied
In field calculation order field "Z" should be second to last, and
"INVENTORY OFFERED" should be last field (on the bottom) and field "U" should be before "V".
Also in "INVENTORY OFFERED" you didn't check for 0 'if(v2==0)'
Copy link to clipboard
Copied
Copy link to clipboard
Copied
You are missing an "else" in "INVENTORY OFFERED" field script.
if (v2==0) event.value = "";
else
event.value = v1/v2;
Copy link to clipboard
Copied
You.Are.Awesome! I totally missed that!!! Thanks!