Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 51
  • Last Modified:

Power Pivot thinks data type is String, however, the type is numeric/decimal from the source data to the cube. i

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......
0
Auerelio Vasquez
Asked:
Auerelio Vasquez
1 Solution
 
Auerelio VasquezETL DeveloperAuthor Commented:
I fixed this by changing the data type in the ribbon.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now