Forum Discussion
Resolver IRound numbers in mixed column
Hello,
I have a specific request to round up numbers in mixed column (Text + Numbers)
Do you have an idea how I can proceed ?
Thank you,
Hi zzinoun ,
Firstly, create a new flag column and check if it is a number or a text. You can use something like this :
Value.Is([Column],type text) -> For textValue.Is([Column], Int64.Type) -> For number
Step 2: create a conditional column - if that flag column is numeric value then you can round it else nozzinoun -> Please hit the thumbs up & mark it as a solution f this helps you. Thanks.
1 Reply
- truptis
Community Champion
Hi zzinoun ,
Firstly, create a new flag column and check if it is a number or a text. You can use something like this :
Value.Is([Column],type text) -> For textValue.Is([Column], Int64.Type) -> For number
Step 2: create a conditional column - if that flag column is numeric value then you can round it else nozzinoun -> Please hit the thumbs up & mark it as a solution f this helps you. Thanks.