This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.
Solved
Complex arithmetic calculations in SQL
Posted on 2016-08-24
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
3 Comments
So what happens when you have 3 different locations in the same country? What you are trying to do is to get the average ((Itemsold_month-Itemsold_
Your formula is getting (from your table) Average = (((Itemsold_month-Itemsold
But you are getting different values in your formula from different rows in your table? Just trying to get the exact way you are trying to calculate. SQL is very powerful doing aggregations and formulas like this, I just want to get it right.
Your formula is getting (from your table) Average = (((Itemsold_month-Itemsold
But you are getting different values in your formula from different rows in your table? Just trying to get the exact way you are trying to calculate. SQL is very powerful doing aggregations and formulas like this, I just want to get it right.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses
Course of the Month12 days, 6 hours left to enroll
636 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.