Hi,
I am working on removing $, % and , from the values like Net Revenue, Net Profit Margin, In such fields we see values in the form $22,333,344 or 78.98% (with comms and %age symbols, we dont need it)
Net Revenue and Net Profit Margin are the integer values.
When I use the Replace function, I get the error message cannot apply the String function to the integer value.
So, I thought of making them (Net Revenue, Net Profit Margin) String using the Select tool and then applying the Replace function, so that I can do the Data Cleaning process. After data cleaning (removing $, % and ,), I thought of converting them back to integer, but this brought me back to where it started. The values again have comma in it.
Can someone please guide?
Thanks,
Radhika
Please use replacechar()
if used in a multi field formula you can replace the current field ",$%" with ""
cheers,
mark
I used the below formula-
Replacechar([_CurrentField_], "$","")
Here, _CurrentField_ is a integer value.
Replacechar is for Strings only
I need to apply the function for the replacing the value in the integer field.
Alyeryx sees your number as a string. In the multi-field formula you can change the type to double.
Replacechar([_CurrentField_], "$,", '')
cheers,
mark