I'm using record type to create a column chart.
The field which I am using is stored as text in the database.
See line 14 in the attached screenshot.
Can I change it to decimal to use in measure?
Discussion posts and replies are publicly visible
This does not work the way you expect. The field parameter in line 14 requires a reference to the field itself. And you cannot add any type casting here. Does the query work for you without any casting? What is the reason to store that total as a text vs. a decimal?
Thanks.I used IDP and stored data in the database as text and did not think about this before.