nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate with DataSet Results

Miss_Anonymus · 2014-12-23T08:21:08+00:00

Hello everbody, i have the following problem: I have two DataSets. these two got an count(*) statement, so they each just return one result. DataSet A: Select Count(*) from tableA, so the result is 345 DataSetB: Select Count(*) from tableB, so the result is 499 Now,…

Miss_Anonymus

Hello everbody,
 
i have the following problem: I have two DataSets. these two got an count(*) statement, so they each just return one result.
 
DataSet A: Select Count(*) from tableA, so the result is 345
DataSetB: Select Count(*) from tableB, so the result is 499
 
Now, I would like to calculate with these two results of the dataSets. But how? I would like to divide the result A trough result B, and then multiply with 100, +%, so that I got:
 
499 / 345 * 100(%), the value which should display in my example would be: 69%
 
 
How can I do this? How has the JavaScript script to be written? (I'm not very familiar with javaScript

so I don't have any idea)
 
 
Thanks already for your help!

Find more posts tagged with

Comments

pricher

Hi,
 
You should be able to do everything in the SQL statement. The following SQL (tested in MySQL and SQL Server) will return the two counts in one row:
 
select a.cnt1, b.cnt2 
from (Select Count(*) from tableA) as a 
cross join (Select Count(*) from tableB) as b
 
Then in your report, use cnt1 and cnt2 to calculate the percentage.
 
Hope this helps,
 
P.

Miss_Anonymus

Thank you very much, the solution is an extendes SQL statement! :-)