• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 53
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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