Help

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

Topic Labels: Formulas
Solved
Jump to Solution
162 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sam_Cholera
5 - Automation Enthusiast
5 - Automation Enthusiast

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

 

1 Solution

Accepted Solutions
seferiannie
4 - Data Explorer
4 - Data Explorer

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. 

See Solution in Thread

2 Replies 2
seferiannie
4 - Data Explorer
4 - Data Explorer

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
5 - Automation Enthusiast
5 - Automation Enthusiast

You legend, thank you!