I am trying to create a calculated measure which is converting a char value to a decimal. I have the following expression:
([Measures].[Base Qty Sold - Detail]/9) * Val([Items].[Item Category5])
I would like to convert the value in Item Category5 which is a char data type to a decimal. The result appears as 0.