Power Pivot thinks data type is String, however, the type is numeric/decimal from the source data to the cube. i
Posted on 2014-12-19
I keep getting this error when i try to change the measure on one of the fields, i know that my fields are numeric, but when i try to us the column as SUM i get this error:
ERROR - CALCULATION ABORTED: MdxScript(Sandbox) (5, 74) The function SUM takes an argument that evaluates to numbers or dates and cannot work with values of type String. i've checked the data type in the sql database, and in the cube, and both are numeric......