Text and Numeric Need Both

[Rhaldhar]

Hi,

below data coming in Alteryx but I need second result in same column through formula. please advise.

Result required.

Thanks,

Rajeev

[cpet13]

@Rhaldhar I'm confused on what you are trying to do. Can you please give some additional context?

[Rhaldhar]

Hi @cpet13  I wanted to correct circle numeric value. but when I use "Tonumber" function then above "Monthly and Average" text value removed. please advise if there is any function through numberic value can correct along with text value. Thanks.

[cpet13]

@Rhaldhar are those all in one field, then? One field can only have one data type; you can have a varchar type hold numbers, but you can't have a numeric type hold text. You could convert the field to a varchar type, potentially.