Power query division while adding column

[ajinkyacgaikwad]

I am dividing two columns named Value (USD) and Weight 

= Table.AddColumn(#"Replaced Value", "unit price", each if [Value (USD)] = 0 or [quantity]=0 then null
else try [Value (USD)]/[quantity] otherwise null)

It seems to me some format issue.

Please help me 

[AntrikshSharma · Accepted solution]

@ajinkyacgaikwad Since your column name has a space and an unsported character for names "(" you need to use #""

Table.AddColumn(
    #"Replaced Value", 
    "unit price", 
    each 
        if [#"Value (USD)"] = 0 
            or [quantity] = 0 
        then null
        else 
            try [#"Value (USD)"] / [quantity] 
            otherwise null
)