Hello all,
I'll be inputting a cost figure in one column, how do I automate a calculation in another column (ideally the same table) to work out the cost price inc VAT (20%)?
Page 1 / 1
my assumptions: current Field is COST, type is currency
what to do: Create new field NEWCOST, type is formula
formula in NEWCOST is: "cost *1.2" this adds 20% to the values under cost.
You legend, thank you!
You legend, thank you!
aww that's nice of you thanks!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.