09-06-2017 02:20 PM
I am trying to change the value type from numeric to character in Visual Analytics Prepare data tool. When I try to run the results
If I just change the type to character() the column shows up as a measure.
If I set a character format, I receive ERROR: Number expression requires a numeric format.
09-06-2017 02:51 PM
Where you drag and drop the formula's to create them? Yes, it needs to be nested inside the main function.
This post has some pictures, if that helps:
12-15-2017 10:27 AM
They asked about Data Preparation tool. TreatAs does not work there, it won't pass validation. TreatAs is only available in Report Designer. You have to manually use INPUT
12-15-2017 10:26 AM
The trick is in the Expression section, use the INPUT function. It is not shown on the drop down of available functions, but if you type it in will work and it will pass validation. As well as not require you to unlock the code.
Parse and TreatAs are NOT available in the Data Preparation tool, those functions only work in Report Designer.