Report Builder Expression For Dividing Using An IIF Statement

Seuban 6 Reputation points

I am new to report builder and am trying to get a percentage of loans funded based on a datafield that has multiple values so I need to be able to distinguish those two values separately and divide it by the total number of applications submitted. For example, Fields!Final_Decision.Value="LO Approved"" Or Fields!Final_Decision.Value="Auto Approved" / Count(Fields!Application.Value.

I was trying to write the expression as a Sum(IIF but it's not working. I used the IIF function to pull the values in the Approved column and it appears to be working as it should =Count(IIf(Fields!Final_Decision.Value="LO Approved" Or Fields!Final_Decision.Value="Auto Approved", "1", Nothing)) but now I need to divide that column by =Count(Fields!Application.Value).

Hope this makes sense. I would really appreciate any help on how I need to write this expression.


SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,349 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Seuban 6 Reputation points

    I have figured it out. I used the expression:

    =Sum(IIF(Fields!Status_.Value="Disbursed", "1", "0")/Count(Fields!Application.Value))

    It is giving me the correct values now.


    1 person found this answer helpful.
    0 comments No comments