Calculation Based On Fields Follow

0
Avatar
Legacy Poster

Hey Guys,

I was wondering if it was possible to create a field and have the output be a multiplication of two other fields. I didn't know if there was a formula that can be chosen, or if we can create something with VBscript. FYI, I'm not well versed with VBscript, so please be gentle.

 

I.E:

    Field 1: Length (96)

    Field 2: Width  (240)

 

    Field 3: Weight (=Field1*Field2)

 

Apparently it's too hard to bring up a calculator for this.....

2 comments

0
Avatar
Shotaro Ito
Comment actions Permalink

Give sharename to Length and Width (from Name in data source), then create a text with VBScript multiline source like

Value = Format.NamedSubStrings("LENGTH").Value * Format.NamedSubStrings("WIDTH").Value 

 

0
Avatar
Legacy Poster
Comment actions Permalink

Perfect! Thanks for the help.   :D

Please sign in to leave a comment.