Forum Discussion
Issue with measure return value - VALUE() - Cannot convert value '1.INF' of type text to type number
As the error message said, the involved column in your calculation is text type. You must convert the values like "5.71429E-05" into numbers then change the data type for both columns into decimal number.
Regards,
After reviewing the measures further, there was another measure being used further down in the chain of calculations that was still of Format General. Changing this to decimal solved the issue. I am not sure why all the other calculations could work with this scientific format without the conversion and PercentileX.Inc could not (as it appears).
Now Resolved.
As the error message said, the involved column in your calculation is text type. You must convert the values like "5.71429E-05" into numbers then change the data type for both columns into decimal number.
Regards,
After reviewing the measures further, there was another measure being used further down in the chain of calculations that was still of Format General. Changing this to decimal solved the issue. I am not sure why all the other calculations could work with this scientific format without the conversion and PercentileX.Inc could not (as it appears).
Now Resolved.