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?
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:
(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?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.