Forum Discussion
Cannot convert value '' of type Text to type Number.
Hello, I have create a calendar date to coincide with fiscal year. It was recently working and just broke with a new upload of monthly data. Wondering how to fix this?
grantsamborn
Solution Sage
Solution SageHi Anonymous
It appears you are using the result of RIGHT() (text type) as a number in the calculation.
Try replacing:
RIGHT( Query[Fiscal Year], 2)
with:
VALUE( RIGHT( Query[Fiscal Year], 2) )
Hello,
Unfortunately that did not work. It is still showing as error.
- grantsamborn
Is it still the same error?
Did you do the replacement in both places?
Is Query[Month_Number] numeric?
Yes, I added to both places and Query[Month_Number] is numeric (1.2).
- grantsamborn
Not sure what it would be.
Here is an example with [Month_Number] as a whole number and [Fiscal Year] as text, using your calculated column.