0

I am having trouble resolving an issue. I have a table on an SSRS report. The query for the table gets the definition, the total count of that definition and calculates the percentage of all the counts. However, as you can see in the image, one field is being populated with another fields data when it should be blank. Are there any SSRS experts out there who can lend a hand?

Here is the query:

SELECT fundingyear
    , loan_type
    , COUNT() AS total_lntype
    , COUNT() * 1.0 / SUM(COUNT(*)) OVER (PARTITION BY fundingyear) as lntype_perc 
FROM vw_LoanRpt 
WHERE loan_type not in ('Line of Credit') 
GROUP by fundingyear, loan_type 

SSRS Table

2
  • What is the query? And the formula?
    – Jacob H
    Sep 14 '18 at 15:37
  • Here is the query. SELECT fundingyear, loan_type, COUNT() AS total_lntype, COUNT() * 1.0 / SUM(COUNT(*)) OVER (PARTITION BY fundingyear) as lntype_perc FROM vw_LoanRpt WHERE loan_type not in ('Line of Credit') GROUP by fundingyear, loan_type Sep 14 '18 at 15:38
0

I found that using a Matrix instead of a table resolves the issue.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.