Level 1

0% to

Level 2

Tip /

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

View all

webnetworksmd
Offline

3

Accepted Solutions

Accepted Solutions
0

Likes

Likes
0

Posts

Posts
4

Discussions

Discussions
1

Questions

Questions
3

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by webnetworksmd
Customize the badges you want to showcase on your profile
Re: If then statement calculation
Magus069
Level 10

Likes

145 likes

Total Posts

1,079 posts

155 solutions
View profile
Magus069
1. You can't have a 'elseif' followed by an 'If' because your 'elseif' is already an 'If' statement2.FormCalc 'if' statement operators are used as letters, so to have 'equal to' is 'eq', to have 'lower than' is 'lt', to have 'greater than' is 'gt', to have 'lower or equal to' is 'le'... etc... To assign a value to a field or variable you must use the '=' signIf (Field1 eq "A") then Field2 = "10"elseif (Field1 eq "B") then Field2 = "8"elseif (Field1 eq "C") then Field2 = "6"endif

Views

134

Likes

0

Replies

0
Re: Error Arithmetic overflow
Level 10

Likes

430 likes

Total Posts

2,709 posts

502 solutions
View profile
Hi,You should wrap your formula into an if expression.FormCalc will always create under/overflows when you try to multiply or devide by 0.if (fieldA ne 0 and fieldB ne 0) then ;add your formula here!endif

Views

78

Likes

0

Replies

0
Re: Arithmic Overflow Error in FormCalc
George_Johnson
Level 6

Likes

21 likes

Total Posts

234 posts

27 solutions
View profile
George_Johnson