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
Solved! Go to Solution.
Views
Replies
Total Likes
Good to hear. If you mark as answered, it will save other's from reviewing the thread.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
It worked! Thank you so much!
Views
Replies
Total Likes
Good to hear. If you mark as answered, it will save other's from reviewing the thread.
Views
Replies
Total Likes