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]

      end.

       

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

       

      Please help me how we can create new calculated field.

       

      Thanks,

      Harsha