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%)?
Solved
In 1 table I'd like to add a column that calculates VAT from another column
+3Best answer by seferiannie
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.
+5my 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.
+5You legend, thank you!
aww that's nice of you thanks!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.