none
How can I get a subtotal of a calculated field in Report Builder 3.0?

    Question

  • I have a calculated field whose value is either 1 or 0 for each record. So, if there are 100 records and 50 of them are 1's the percentage would be calculated as 50%. How can I get this value in a field either in the footer or header regions?
    Wednesday, November 13, 2013 7:38 PM

Answers

  • Hi Nine_Iron,

    If I understand correctly, you have a calculated field with 1 and 0 values. You want to calculate the 1’s percentage value and display the percentage value in the report footer or header.

    We can use a text box to display the value in the report footer or report header. Suppose we have a field Amount in our dataset. Please refer to the expression below:
    =Sum(IIF(Fields!Amount.Value/2=1,1,0),"DataSet1")/Count(Fields!Amount.Value/2,"DataSet1")
    (Note: Then, we can configure the text box “Number” property with Percentage value.)

    If there are any misunderstanding, please feel free to let me know. And could you please post you dataset with sample data and the calculated field’s expression?

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    Thursday, November 14, 2013 8:20 AM
    Moderator