In 1 table I'd like to add a column that calculates VAT from another column

[Sam_Cholera]

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%)?

[seferiannie · Accepted solution]

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. 

[Sam_Cholera]

You legend, thank you!

[seferiannie]

aww that's nice of you thanks!