# Add amount to number column if number available

Hi guys,

I am currently trying to use the formula column to add 20KG to a number if a value is present.

“if({weight(unpacked)} is “something” then + 20KG”)

The formula column should output the SUM of weight(unpacked) + 20KG, for example if weight(unpacked) were 100KG the formula column should output 120KG.

And is there a way to have the KG after the value.

Cheers

Justin

@JustinB1994

What kind of column is {weight(unpacked)}?

Hi Jim,

It is a number column.

Cheerd

@JustinB1994

This should do it:
`IF({weight(unpacked)} > 0, {weight(unpacked)} + 20)`

The best way to set the units is to update the column summary:

1 Like

Hi Jim,

The formula column is coming up with “true” if the number column is empty.

Also my number settings looks different to yours.

Would you have a solution for these issues.

in the meantime I have created a temporary solution using two formula columns and two numbers columns.

NUMBERS COLUMNS
“{WEIGHT(UNPACKED)}”
“{PALLET}” =20KG

FORMULA ONE
“({WEIGHT(PACKED)})”
IF(AND({WEIGHT (UNPACKED)}<1,{PALLET}>0),“”,“{FORMULA ACTION}KG”)

FORMULA TWO
“{FORMULA ACTION}”
SUM({WEIGHT (UNPACKED)}+{PALLET})

Is there a simpler way to do this?

Cheers.

@JustinB1994

Oops.

Just change formula 2 to this:
`IF({weight(unpacked)} > 0, {weight(unpacked)} + 20, "") `

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.