How to convet this percentage calculation of sql in c# function

Question

5.00/5 (1 vote)

See more:

How to convet this percentage calculation of sql in c# function?

SQL

select isnull(CAST(ceiling(ROUND(cast(cast(sum(value) AS NUMERIC) / cast(sum(total) AS NUMERIC) * 100 AS DECIMAL(8, 2)), 0)) AS INT), 0) as percentage

Posted 4-Mar-16 20:35pm

Ashishmau

Updated 5-Mar-16 4:33am

Maciej Los

v2

Add a Solution

Comments

OriginalGriff 5-Mar-16 4:15am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
So explain what you are trying to do, what you have tried, where you are stuck, and what you need help with.
And probably, why your SQL is casting stuff so much...
Use the "Improve question" widget to edit your question and provide better information.

3 solutions

Solution 2

Check this:

C#

double avalue = 4.0;
double total = 31.0;

var result = total == 0 ? 0 : Math.Round((avalue/total)*100);
Console.WriteLine("{0}:{1}={2}", avalue, total, result);

Posted 5-Mar-16 3:51am

Maciej Los

Solution 3

And another option...

This one assumes that value and total are integers and you want an integer result

C#

var value = 4;
var total = 31;
var perc = (total == 0) ? 0 : (int)Math.Ceiling(value * 100.0 / total);

Posted 5-Mar-16 4:33am

CHill60

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Accepted Answer · 2016-03-04T22:25:00

Solution 1

C#

var value = 123.45;
var total = 1000.1;
var perc = total == 0 ? 0 : Convert.ToInt32((value * 100) / total);

Posted 4-Mar-16 22:25pm

RickZeeland

Comments

Ashishmau 5-Mar-16 5:48am

Its not working properly. Suppose value = 4 and total = 31. In this case, sql query returns 13 while your above code returns 12. I want exact returns given by sql query.

RickZeeland 5-Mar-16 9:32am

var value = 4.0;
var total = 31.0;
var perc = total == 0 ? 0 : Convert.ToInt32(Math.Round((value * 100) / total));

CHill60 5-Mar-16 10:34am

Did you know you can use the Improve solution link to change your solution