Forum Discussion
Calculating % Yield measure
Hello,
I am trying to make a table with the Yield rate(which is total enrolled divided by total applied) by year. Is there a way to do it? A formula?
My Data looks like this:
Create a Measure (call it anything that works for you). Since you want % at the ROW level, the formula doesn't have to take into account any filtering or grouping...
Measure = SUM(Table1[Admitted]) / SUM(Table1[Applied])
Raw Data I entered based on your screen shot & Matrix with Rows = R&E, Columns = Year, & Values = your measure
3 Replies
It looks like a simple request, but depending on how you want to display the data, it coudl be more complciated. I'm assuming you have mutliple years of data not displayed in your sample? Do you want the Yeild by line to the right of the data, or a total at the bottom for all 'Race and Ethnicity' by year?
Can you mock up your desired output?
FOrrest
I was hoping for something like this:
Create a Measure (call it anything that works for you). Since you want % at the ROW level, the formula doesn't have to take into account any filtering or grouping...
Measure = SUM(Table1[Admitted]) / SUM(Table1[Applied])
Raw Data I entered based on your screen shot & Matrix with Rows = R&E, Columns = Year, & Values = your measure
