Level 1

0% to

Level 2

Tip /

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

View all

Community profile webnetworksmd Level 1
Job title here
Location here

Level 1

Joined the community 12-02-2012 12:53:20 PM
Offline
If then statement calculation
webnetworksmd
Level 1

Likes

0 likes

Total Posts

4 posts

0 solutions
View profile
webnetworksmd
I am having difficulty getting a statement to work. Basically I want to have field 1 take "x" value and then return an "x" value in Field 2. 3 options for field 1 that returns the value of that option into field 2. This is what I have that returns errors:If (Field 1 eq "A") then (Field 2 eq "10")elseifIf (Field 1 eq "B") then (Field 2 eq "8")elseifIf (Field 1 eq "C") then (Field 2 eq "6")endifCan someone help me with the correct syntax to perform this operation? I am sure I have something wrong ...

Views

594

Likes

0

Replies

1
Error Arithmetic overflow
webnetworksmd
Level 1

Likes

0 likes

Total Posts

4 posts

0 solutions
View profile
webnetworksmd
I have multiple number fields that perform calculations based on GPA, Credits, Quality Points etc.. the last two fields divide previous returned values but when the form opens I get the overflow error. How do you surround the calculation with a check to assure the variables are non zero, non-null?How can you prevent the fields from trying to calculate until the form is loaded?Any help is greatly appreciated.

Views

517

Likes

0

Replies

1
Arithmic Overflow Error in FormCalc
webnetworksmd
Level 1

Likes

0 likes

Total Posts

4 posts

0 solutions
View profile
webnetworksmd
I get the overflow error when my form opens ( I know it is cuased by two division fields at the end of my form). I have mutlple fields that do computations based on other fields. How do I set a default value for a number field? How can you establish a variable that isn't set until the end of the load process.. how would you do that for a field?

Views

604

Likes

0

Replies

1
Re: FormCalc error-arithmetic overflow/underflow
webnetworksmd
Level 1

Likes

0 likes

Total Posts

4 posts

0 solutions
View profile
webnetworksmd