Color Coded percentages

[ryanb66865504]

Trying to make cells change color based upon a percentage using validation script in Adobe Acrobat Pro DC. The text field is a calculated value from other text fields in simplified field notation (i.e. Text42/Text44). 

Custom Validation Script:

var v = Number(event.value);
v = v.toFixed(2);

if (v<=0.55){event.target.fillColor = color.red;}else if (v>0.55 && v<=0.70){event.target.fillColor = color.magenta;}else if (v>0.70 && v<=0.84){event.target.fillColor = color.green;}else{event.target.fillColor = color.cyan;}

unfortunately, the calculated values all return red. (i.e. 0.94375 gives me a red background).

Any help would be greatly appreciated.

RB

[Nesa Nurani]

Your code is working fine for me.

Did you check field calculation order?

[ryanb66865504]

No! I am not sure how to do that?

[ryanb66865504]

I found it, however, after ensuring the order. I am still getting red.

[Asim123]

Can you share your file?

[ryanb66865504]

Yes. Note sample data, page 7.

[Asim123]

Can't download.

[ryanb66865504]

This link

[George_Johnson]

As a test, try getting rid of that second line of code.

[ryanb66865504]

I actually just added that as a potential fix. It didn't work before either. thank you though!

[George_Johnson]

A validation script is triggered when the field value changes, so be sure to change the field value to trigger the code.

[Asim123]

For me everything works fine.

[ryanb66865504]

Weird. I still get red cells

[George_Johnson]

Check the JavaScript console (Ctrl+J) to see if any errors are reported. Also, try saving the file, closing Acrobat, and reopening to see if it makes a difference.

[ryanb66865504]

video  

See above clip. And I notice that 8.57% returns cyan. I am at a loss

[George_Johnson]

While "8.57%" results in cyan, a value of 8.57 results in red. That's a hint.

[ryanb66865504]

I did find that. When you tested Asim, did you enter raw numbers, or did you use the calculated percentages?

[ryanb66865504]

because the 62.86 entered in the WorkKeys slot seems to work.

[ryanb66865504 · Accepted solution]

Got it. I had to change every cell that was used to calculate Text42 and change it back. I couldn't just retype the numbers to update. thank you both for helping me trouble shoot!