Skip to main content

Search

Search

Simple Calculation

Comments

2 comments

  • Avatar
    Peter Thane

    You would need to make your calculation field a VB Script field and then add in some simple code to achieve this as shown below.

    I would also suggest for ease of reference that you "name" the two source fields using this ringed button as you can then call these values simply in your VB

     

    A Multi-line VB script could be used to deploy this but if the data is coming from a database or a data entry form value then making it an Event Controlled Script that performs the action OnNewRecord if they are both databased fields or OnPostPrompt if a Data Entry is used for example, may be a better way to go to make sure that the valid entered data is been used.

     

    0
  • Avatar
    Karen LeGeyt

    thank you -that was just the thing to help me along my way. Have a great day!

    0

Please sign in to leave a comment.