Forum Discussion
Helper IIF and Concatenate Custom Columns
I want to use the following:
If metric unit equals %, then concantenate metric value and metric unit, otherwise just return metric value. I'm using the formula below however it doesnt like this.
Try changing it back to a numeric field as the last applied step. Since the applied steps are in order, after the new field is created, you can change Metric Value back to numeric.
3 Replies
- audreygerred
Super User
Hello! To concatenate you can't have numeric fields and text fields, so you would have to first change the Metric Value to Text, then create a concatenated field.
Next, you would create a conditional column
Then, you can remove the concate field since you don't need it.
daniellamoore29I cant change my metric value column to text as this changes all my visuals, it shows error.
Is there another way?
- audreygerred
Try changing it back to a numeric field as the last applied step. Since the applied steps are in order, after the new field is created, you can change Metric Value back to numeric.