Changing a calculated column (measure )as category with % symbol

[Akhila1]

In creating a SAS viya dashboard I want the following calculated column as a category with % symbol

'Graduated in 2 Years'n / 'Enrolled (Distinct Count)'n

[Sam_SAS]

Hello,

You can apply a Percent format to the numeric value, if you just want to display the % symbol.  (Change the data item properties in the Data pane.)

If you really need the value to be a category value, you can use the Format() operator.

For example,

Format('Engine Size (L)'n / 'Horsepower'n, 'PERCENT6.0')

returns a category value.

Let us know if that helps,

Sam

[Akhila1]

I really need the value to be a category value. Format( 'Graduated in 2 Years'n / 'Enrolled (Distinct Count)'n,'PERCENT6.0')I get an error. Type mismatch. expected type at this location is Aggregated measure, type of this item being applied is character. Operand can only be aggregated, but this operator does not support aggregation. Thank you,

[Sam_SAS · Accepted solution]

Oh, I see. The problem is the nested operations when you have an aggregated measure (Distinct Count) in the expression. I think the best workaround is to pre-calculate the distinct count as part of your data preparation.

If you have the very latest version of VA (2024.05), you can work around this by calculating the distinct count as part of an expression-based parameter.