Add 10% To Database Value

Legacy Poster

• June 26, 2015 18:34

I want to retrieve the quantity from a database file, which is easy. But when I want to print I want to add 10% to that so it prints quantity + 10% of quantity...

 

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • June 29, 2015 07:48

  Set the quantity to be set by a data source with the data source as an event based VB Script.  You would then reference the appropriate field containing the quantity value, add 10% to it and make sure the result is an integer by using the Int() function.  Something like this should do it:  Int(Field("table.qty",1) + (Field("table.qty",1) * 0.1))

  0

Please sign in to leave a comment.