I'm making a crosstab. My raw data is a result by 2 categories. 1st data column is an average of the result, 2nd column is a count of the results, 3rd column is a count of results less than a certain value (number of "failures"), 4th column is supposed to be the percentage of the 3rd column/2nd column. Basically it's a failure percentage.
For the 4th column, i made a calculated item of (column_2)/(column_3). But since I'm forced to choose an aggregation for the calculated measured value, I don't get the actual raw percentage calculation.
In case it matters, I have the report filtered for the current month/year.
I figured out my problem. I didn't create New Aggregate Measures, I just changed the aggregations of data columns. When I created new aggregate measures, I was able to get calculate percentages using them like I needed.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.