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

    How to Convert LBS into kgs

    Harsha Reddy

      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]



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


      Please help me how we can create new calculated field.