Subtracting values between two fields

Here are some quick points:

field1, "firstnumber" = number/editable
field2, "secondnumber" = number/editable
field3, "resultnumber" = number/computed

User enters a number value in field1
User enters a number value in field2
Field3 automatically shows the value of field1 minus field2

What formulas do I need in all three fields for this to work, including checking to make sure that user enters a number, (as opposed to text), etc.?
jtpattenAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

qwaleteeCommented:
You don't need any formula in the first and second, Notes will take care of validating that they are numbers.

In the third, the formula should be:

result := firstNumber - secondNumber;
@If(@IsError(result); ""; result)
0
HemanthaKumarCommented:
Usually if you enter data type other than defined by field information.. the app will automatically raise the data type mismatch errors.

The formula is quiet simple.. in the default value section of the field3 enter this formula

@If(@IsNumber(Field1) & @IsNumber(Field2); FIELD1 - FIELD2; 0)

~Hemanth
0
jtpattenAuthor Commented:
qualetee,

Notes accepts this but nothing shows in the result field when numbers are entered and the form is refreshed?
0
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

jtpattenAuthor Commented:
HemanthaKumar,

Your answer seems to always post a zero in the results field no matter what is entered in the other two fields?
0
jtpattenAuthor Commented:
HemanthaKumar,

Sorry, your answer does work, I had something else hosed.

Respond back so I can accept for you.

Thanks,

Jack
0
HemanthaKumarCommented:
The problem is the computed field will not just refresh unless something triggers

1. Hit F9 key to manually refresh
2. When you exit of field2, write a script which triggers a refresh

Dim ws as New NotesUIWOrkspace
ws.UIDocument.Refresh

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jtpattenAuthor Commented:
HemanthaKumar

What would I have to add to the results field formula so that if there is nothing entered in the first two fields the results field will show blank?

Right now it shows a zero.
0
qwaleteeCommented:
Use my formula, and it will show blank.  Use Hemantha's formula, it will show zero.
0
HemanthaKumarCommented:
@If(@IsNumber(Field1) & @IsNumber(Field2); FIELD1 - FIELD2; "")
0
qwaleteeCommented:
If this is  VERY SIMPLE form, you can also enable th form property, "Automatically Refresh Fields," which would update as soon as you tab out of field 2.

This isn't work for a Notes AD I class, is it?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.