Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

SOLVED

## Need help with an if statement

Level 2

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

1 Accepted Solution

Level 6

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

0 Replies

Level 6

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.

Level 2

It worked! Thank you so much!