Report Calculation of Percentage is Inaccurate

I have a report that Sums several columns and uses the sums of two of the
columns to calculate a simple percentage.
=Sum(Fields!Col1.Value)/Sum(Fields!Col2.Value)
= 3781/4756
The resulting calculated percentage in the report is 76%. The actual
percentage is 79.4%.
I've searched MS Reporting Services site but can find nothing that addresses
calculation errors. Has anyone else had this problem? Does anyone know of a
fix for this?Could you put Sum(Fields!Col1.Value) and Sum(Fields!Col2.Value) into
separate textboxes to make sure they are 3781 and 4756?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lynn" <Lynn@.discussions.microsoft.com> wrote in message
news:4B948010-B27C-45A4-95BA-C89DF5A2B25D@.microsoft.com...
>I have a report that Sums several columns and uses the sums of two of the
> columns to calculate a simple percentage.
> =Sum(Fields!Col1.Value)/Sum(Fields!Col2.Value)
> = 3781/4756
> The resulting calculated percentage in the report is 76%. The actual
> percentage is 79.4%.
> I've searched MS Reporting Services site but can find nothing that
> addresses
> calculation errors. Has anyone else had this problem? Does anyone know
> of a
> fix for this?
>|||Thanks for your response, however, I finally figured it out ... I was asking
for a line item value to compute the summed values percentage. So Rpt Svcs
was grabbing the values from the 'First' record in the group instead of the
summed values for the 2 columns. The fix is something like this ...
=Sum( Fields!Col1Sum.Value )/SUM( Fields!Col2Sum.Value)
"Lev Semenets [MSFT]" wrote:
> Could you put Sum(Fields!Col1.Value) and Sum(Fields!Col2.Value) into
> separate textboxes to make sure they are 3781 and 4756?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Lynn" <Lynn@.discussions.microsoft.com> wrote in message
> news:4B948010-B27C-45A4-95BA-C89DF5A2B25D@.microsoft.com...
> >I have a report that Sums several columns and uses the sums of two of the
> > columns to calculate a simple percentage.
> > =Sum(Fields!Col1.Value)/Sum(Fields!Col2.Value)
> > = 3781/4756
> > The resulting calculated percentage in the report is 76%. The actual
> > percentage is 79.4%.
> >
> > I've searched MS Reporting Services site but can find nothing that
> > addresses
> > calculation errors. Has anyone else had this problem? Does anyone know
> > of a
> > fix for this?
> >
>
>

Report Builder field calculate problem

Hi,
I have a problems with the field calculations. NOT Work.
When i tried calculate total sales for a specific store, this duplicate or
3, 4, 5 times the total sales.Hello Guillermo,
I would look closely at you data source view and check that there is
nothing funny with the table joins you are basing your model on. This
is the main place where something goes wrong and causes the issue.
I would also review the report you are creating and check there are no
many to many possibilities with entries you have selected.
If you are still not having any luck have a look at the blog entry
describing how to trap the SQL generated by Report Builder.
http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx
Hope this helps
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/

ReporItems referring to a cell containing a subreport?

Hi guys,

i have a column in a report that must calculate a percentage based on two columns that follow them. I am aware that i can use the ReportItems! collection for this, but one of the columns i need to reference is actually a subreport because its data comes from a different source. It is just a single cell subreport, which makes it appear totally part of the table it is in. Is this possible? Just to be clear, what i want is an expression like this in my cell:

= FormatPercent( ReportItems!CurrentEarnings / ReportItems!BudgetedEarnings )

the BudgetedEarnings cell is actually a subreport, but all i want is the text it is showing.

Thanks for any help or suggestions!

sluggy

No, referring to a report item in a subreport is not allowed.

|||Dang! Thanks |||Hi, how did you get around this issue? I am trying to do the same thing.

ReporItems referring to a cell containing a subreport?

Hi guys,

i have a column in a report that must calculate a percentage based on two columns that follow them. I am aware that i can use the ReportItems! collection for this, but one of the columns i need to reference is actually a subreport because its data comes from a different source. It is just a single cell subreport, which makes it appear totally part of the table it is in. Is this possible? Just to be clear, what i want is an expression like this in my cell:

= FormatPercent( ReportItems!CurrentEarnings / ReportItems!BudgetedEarnings )

the BudgetedEarnings cell is actually a subreport, but all i want is the text it is showing.

Thanks for any help or suggestions!

sluggy

No, referring to a report item in a subreport is not allowed.

|||Dang! Thanks |||Hi, how did you get around this issue? I am trying to do the same thing.