Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

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.?
0
jtpatten
Asked:
jtpatten
  • 4
  • 3
  • 3
1 Solution
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 4
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now