3 Replies Latest reply on Jul 25, 2018 3:49 AM by Kashish Bhola

# How to Convert LBS into kgs

Hi All,

In my Data table i have a columns like Service Provider, Total Weight , Weight M.

Here i need to convert lbs into kgs. wherever lbs is there should convert into Kgs.

And I need to create New column Converted Weight in kgs,

Expected View :

Calculated column :

If [Total Weight]=[LB] then [Total Weight]*0.45359237

else [Total weight]

end.

But above calculation was showing error (We can't compare measure with string).

Thanks,

Harsha

• ###### 1. Re: How to Convert LBS into kgs

hi Harsha,

Hope all is well!

I think your formula should be

If [Weight M]="LB" then [Total Weight]*0.45359237

else [Total weight]

end.

Let me know if that doesn't do the trick

• ###### 2. Re: How to Convert LBS into kgs

Hi Harsha,

You can try below logic:

If [Weight M]='LB'  then [Total Weight]*0.45359237

else [Total weight]

end.

• ###### 3. Re: How to Convert LBS into kgs

Hi Harsha,

Simon Runc Is very Right You can use the calculation:

If [Weight M]="LB" then [Total Weight]*0.45359237

else [Total weight]

end.

For more Clarity I've attached the workbook

2 of 2 people found this helpful