You must Sign In to post a response.
  • Category: SQL Server

    SSRS Expression to calculate percentage of a Data Field

    In the report dataset,i have 3 fields named,
    UserName
    TotalNumberofRequests
    Requests with Quality Check.
    I have to set a target line to display 90% of the Requests with Quality Check.
    However, i am unable to set an expression to calulate 90 % of the Requests with Quality Check.
    Please anybody help me to set the expression.
  • #756194
    What do you mean by 90% of the quality check column,

    Please elobarate your requirement.

    Thanks & Regards
    Anil Kumar Pandey
    Microsoft MVP, DNS MVM

  • #756197
    The requirement is there should be a target line which should be set at Y-axis
    Target line will display at 90% of the Requests with Quality Check field for each user.
    So, i need an expression to calculate 90% of the Requests with Quality Check Data Field

  • #756234
    Can anybody reply the question please and help me out.
    I still have not solved teh problem..

  • #756259
    The Fuzzy Lookup transformation is used to performs the data cleaning task.

    http://www.dotnetspider.com/resources/45754-SSIS-Fuzzy-LookUp-Transformation.aspx

    Data cleansing is used to correcting or removing corrupt the data
    http://www.mssqltips.com/sqlservertip/2593/getting-started-with-data-quality-services-of-sql-server-2012-using-ssis--part-4/


  • Sign In to post your comments