Need help with an if statement

[Former Community Member]

I have three variables: subA, subB, and subC. Originally I had the math such that (subC=subA/subB) and then I implemented a pattern so subC showed up as a percentage. That resulted in the possibility of subC being > 100%, which the client did not like. They asked if subC > 100%, that N/A appear. So I wrote the following script, which I'm sure is wrong because I don't have a lot of scripting experience and I got a syntax error. Thank you in advance for your assistance.

form1.#subform[9].subC::calculate - (FormCalc, client)

if (subC > 1) then

     subC = "N/A"

elseif  (subC <= 1) then

     (subA/subB = subC)

endif

[Former Community Member]

You are looking at the value of subC before you assign a value to it.

Maybe:

subC = subA/subB

if (subC > 1) then

     subC = "N/A"

endif

If a number field, you'll probably get an error setting it to a string though. You'll probably have to change to a Text Field and probably have to accomodate the "N/A" in the pattern.

[Former Community Member]

It worked! Thank you so much!

[Former Community Member · Accepted solution]

Good to hear. If you mark as answered, it will save other's from reviewing the thread.