weight measure conversion

modara — Sun, 20 Jun 2021 14:09:48 GMT

I need help or idea

I have some products in kilogram and some product as packet in a same single column

but i know i have 25 packeted product and they are 200 gram each

now I need help how I can calculate these 25 packeted product to convert them from 200 gram to kilogram and keep them to products that are already in kilogram a same single column

so requirement are,

1) convert packed product 200 gm to kilogram

2) and keep packetd product in same column with previously product that are already in kilogram

Re: weight measure conversion

modara — Sun, 20 Jun 2021 14:10:03 GMT

1) As you see in one column Product name (in KG, Gram, Pack and piece)

2) Quantity column is in kilogram (i.e. Beef Back Leg 2 kilo, 1.635 kilo)

3) Quantity column also has Pack and piece that are written 1 or 2 or so on

(i.e. 12 Pcs Brown Egg Pack- 1 or BBQ Sauce 510gm- 1)

3) here some Product name that are Pack and piece are in 200 gram like 12 Pcs Brown Egg Pack- 1 but in quantity it shows 1 or 2

now I need help how I can calculate these products (12 Pcs Brown Egg Pack- 1 or BBQ Sauce 510gm- 1) to convert them to kilogram and keep them to products that are already in kilogram a same single column

Product name (in KG, Gram, Pack and piece)	Quanitity (in KG, Pack and piece)
Beef Back Leg	2
Beef Back Leg	1.635
Beef Back Leg	5
Beef Back Leg	4.065
Beef Back Leg	1.085
Beef Back Leg	2.925
Beef Back Leg	1.28
Beef Back Leg	5.74
Beef Back Leg	1.165
Beef Back Leg	3.13
Beef Back Leg	1.58
Beef Back Leg	2.025
Beef Back Leg	1.975
Beef Back Leg	1.92
Beef Back Leg	3
Beef Back Leg	2.85
Beef Back Leg	1
Beef Back Leg	1
Beef Back Leg	3.22
12 Pcs Brown Egg (Pack)	1
12 Pcs Brown Egg (Pack)	1
BBQ Sauce 510gm	1
BBQ Sauce 510gm	1
BBQ Sauce 510gm	1
12 Pcs Brown Egg (Pack)	2
12 Pcs Brown Egg (Pack)	2
12 Pcs Brown Egg (Pack)	2s

topic weight measure conversion in App Development

weight measure conversion

Re: weight measure conversion