asked on Complex arithmetic calculations in SQL
Hi everyone,
I have a situation where I have to get the result in SQL of somehow complex calculation which we were previously doing it in Ms Excel. Attached is the file to see the table structure and data. Now by keeping in mind the structure of the table, kindly help how to solve the following formula for "UK" where "LocationID" is different but "LocationSubID" are same.
Average = (((Itemsold_month-Itemsold
This formula will be used to calculate for both entries of "UK" but their will be a single value, say "Average"
Please guide. If need any further clarification then please let me know.
P.S. This formula can be simplified but need to calculate the result using above mentioned formula only
Thanks.
Sample-table.xlsx
I have a situation where I have to get the result in SQL of somehow complex calculation which we were previously doing it in Ms Excel. Attached is the file to see the table structure and data. Now by keeping in mind the structure of the table, kindly help how to solve the following formula for "UK" where "LocationID" is different but "LocationSubID" are same.
Average = (((Itemsold_month-Itemsold
This formula will be used to calculate for both entries of "UK" but their will be a single value, say "Average"
Please guide. If need any further clarification then please let me know.
P.S. This formula can be simplified but need to calculate the result using above mentioned formula only
Thanks.
Sample-table.xlsx
Microsoft SQL ServerMicrosoft SQL Server 2008
Last Comment
hennanra3
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Basically, if you could provide one concrete example from your table of your calculation, I should be able to generate the query.
ASKER
Yes agree SQL is indeed very powerful in doing aggregations. Used "SUM" and their result in query to get the result.
Thanks.
Thanks.