<div>
<div class="content wysiwyg-content">
Summarize SQL values that need to be divided with remainders.<br />
<br />
I need to summarize a group of SKU's and their weights. the challenge I have is that that the weight field has a value that needs to be divided by 100 to get the correct weight<br />
i.e. Sku#1 has a value of 15200 which should actually be 152.00 pounds<br />
Sku#2 has a value of 3 which should actually calculate to .03<br />
Sku#3 has a value of 15 which should actually calculate to .15<br />
<br />
The summarized value for the 3 Sku's should then = 152,18 pounds<br />
<br />
How would I formulate the sku values to summarize as shown?<br />
<br />
Thanks
</div>
</div>


Summarize SQL values that need to be divided with remainders.

I need to summarize a group of SKU's and their weights. the challenge I have is that that the weight field has a value that needs to be divided by 100 to get the correct weight
i.e. Sku#1 has a value of 15200 which should actually be 152.00 pounds
Sku#2 has a value of 3 which should actually calculate to .03
Sku#3 has a value of 15 which should actually calculate to .15

The summarized value for the 3 Sku's should then = 152,18 pounds

How would I formulate the sku values to summarize as shown?

Thanks

Sum unique weight for mutiple groups in a product shipment list

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.