Thanks. This is what I have now:if (NumericField1[1] ne 0) (NumericField1[1]-NumericField1[0])/NumericField1[1]*100 endifThe script editor is telling me there is an error at col 27, which is where my formula starts. Is there supposed to be a comma, or anything?

Thanks. If I set 1 as default value, the form opens with that screen (I assume I'd have to set both values to 1 as default).How would I go about testing the values? Is there a code that would work like an Excel "IF" function, to where the calculated field would 'wait' until the values are filled in ...

Thanks, it works.Now when I fill the form though, how do I get rid of this annoying message when I type in the 1st number?Once I hit OK, it's fine, but it breaks up the flow of filling out the form...Thanks!

Hello,This is most likely a simple question... I'm trying to calculate a variance %. I have the script editor open, I picked "calculate" under "show" and I'm left with this:form1.#subform[1].NumericField1[2]::calculate - (FormCalc, client)I obviously don't know anything about script, so what do I ad...

That's what I'm trying to avoid having to do... I really just want the % sign to show up...

Hello,I would like a numeric field to appear as a percentage as it is typed. For example, if I type 15 I want the field to populate 15% (not 1500%).How do I need to set the display/edit/validation/data patterns?Thank you,Caroline

Perfect, thanks so much for your help!Caroline

Thank you. It works, if I enter 6 for example I get the error message; however, my "6" stays in the box when I close the message and tab out. Is this supposed to happen?

Awesome, thank you!I'm not familiar with the validation process/script. Would I be pasting this code somewhere and where?Thanks!Caroline

Perfect, thanks!