My report is based on a stored procedure and the columns are outputted to a table in the report.
I would like to create a expression as a percentage which I require help with?
At the moment, I have a shared dataset pointing to the SP, so if possible, can this expression be created in the existing shared dataset as a new calculated field?
The calculation needs to use one of the fields called "Output" and do a count of how many 'Y' are in that field and then divide by the total number of rows in the dataset.
So, 17000 (Y's) / 20000 (Total number of rows)
The answer will be just an expression displayed in the title and not required in the table?