New Column for Fixed Amounts

[tomtingley]

Hi,

I've attached a file.

I'm looking to create a new column with certain values applied to certain buildings.

For example, "Country 1", I want in the new column to be "4%.

Country 2 to show 10% in the new column.

I'm not sure how best to do this.

[binuacs]

@tomtingley What is the logic to calculate the percentage values ?

[tomtingley]

@binuacs I just want to use the same value every time, so I guess there's no logic behind it.

I just want to create a separate column which shows 4% for Country 1 and 10% for Country 2, as examples.

Once I understand how to do it, I can add in for other countries myself.

Hope that makes sense.

[Raj]

why don't you use the append tool to achieve this

[Raj]

pfa

[binuacs · Accepted solution]

@tomtingley Add a formula tool and use the If Else formula for the new column