How to calculate two columns in SSRS , RDLC report ? when grouped by row group

Question

1.00/5 (1 vote)

See more:

I created SSRS RDLC report ,table grouped by raw group. when i try to Sum two column values, it calculate as a raw, and my row's hidden fields also calculate. how to solve it?.

What I have tried:

=Sum(Fields!RiskFactor.Value *Fields!RiskRating.Value)

cl1                 cl2                    cl3
      3                   1                      3
      3                   4                      12
      3                   1                      3
      2                   1                      2
                                       
                                      Total     23

Posted 26-Apr-17 23:40pm

Member 13155864

Updated 27-Apr-17 0:32am

v3

Add a Solution

Comments

CHill60 27-Apr-17 5:54am

That is not summing the fields it's summing the product of the fields

Member 13155864 27-Apr-17 6:00am

i need to get Sum of two column multiplication. how to do that ?

CHill60 27-Apr-17 6:03am

That is what you are doing, but your question said you were trying to sum the column values.
You could try = (Sum(Fields!RiskFactor.Value) * Sum(Fields!RiskRating.Value))

Member 13155864 27-Apr-17 6:14am

Result:

cl1 cl2 cl3

3 1 3
3 4 12
3 1 3
2 1 2

Total 23

Total should 20, how to solve this problem?

cl1=Fields!RiskFactor.Value
cl2=Fields!RiskRating.Value

Abhipal Singh 27-Apr-17 7:16am

Could you let us know the formula being used for "Total". Also, why don't you sum c13 only?

Member 13155864 27-Apr-17 23:15pm

cl1 c12 cl3 cl4
3 1 3 test

Total Risk Score 6

cl1= Risk , cl2=Risk Rating , cl3=Final Risk Score cl4=Observation

Final Risk Score = Risk * Risk Rating
= 3 * 1
= 3
Problem is the Total Risk Score. It should be 3 but Value show as 6. I think Hidden values also add to Final Risk Score. Can you give Me a solution?
Final Risk Score = Sum(Filelds!RiskFactor.value * Fields! RiskRating.value)
I used that for get the Total Risk Score.

My Raw Grouped structure of SSRS RDLC .
Row Groups

[(AreaID3)
[(SubAreaid3)
[(QuestionCode2)
[(QuestionCode3)
[QuestionID3
[RiskFactor2
[RiskRating2
[(RiskRating3)
[QuestionID4
[(SubAreaId4)
[(ObservationID2)
[(QuestionID5)
=(Details3)

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)