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,
Thanks, I had tried this already, using the modeling tab, in the formatting group, I changed the Format to Decimal number on all of the measures and fields related to the calculations I am using. It turns out that another measure in the Lower Middle measure was where the error was pointing. I navigated to the measure and changed the Formats of the Measure and the Measures in the divide calculation as well as surrounded them with a Value function call. This calculation still works as expected... When using it in the Percentile Function I still get the Text to Number error message even though all my Formats are in Decimal.