Round Off

I have following data set with multiple columns

A	A%	B	B%	C	C%
2.45666	1.87654%	3.689	12.3364788%	6.4567	10.456733%

I would round off the data using multi field formula
i have used this formula
ToString(Round(ToNumber([_CurrentField_]), 0.01)) + '%'

for this formula all columns are getting % symbol

i would like to add % symbol only for those columns with %

Data Investigation

Accepted answers

binu_acs

@Divyajyothi7 Attached the updated workflow

RoundOFf_080623.yxmd

All comments

caltang

You can use a Multi-Field Formula, and you can select the Fields of interest for you to convert them.

If you'd like to fully automate it, then you can use a combination of Tranpose Tool + IF Contains([Name],"%") THEN your formula to include %, else do not include.

If you'd like, kindly provide some sample data and we can show you how. There's two ways about it, really depends on your preference. Though the latter is more automated.

binu_acs

@Divyajyothi7 One way of doing this with Transpose and Cross Tab tools

RoundOFf_080623.yxmd

Qiu

@Divyajyothi7
Just add to @caltang We can make a more dynamic by using conditional statement.

0608-Divyajyothi7.yxmd

Divyajyothi7

@Qiu from your formula only % columns are getting roundoff

I would like to roundoff all the columns which are in string format

i have updated the formula but non % columns are not changing

if contains([_CurrentFieldName_],'%')
then ToString(Round(ToNumber([_CurrentField_]), 0.01)) + '%'
else ToString(Round(ToNumber([_CurrentField_]), 0.01))
endif

sparksun

Here is my solution.

roundoff.yxmd

binu_acs

@Divyajyothi7 The amount which contains % are in string type and the rest are in double, in that case, the above formula should work. Can you provide your sample file with and expected output?

Divyajyothi7

@binu_acs

Please consider all columns as string

I have sorted the data before, I don't want use any new crosstab or transpose tools

is it possible to solve using multifield formula?

so that my order of columns won't change

binu_acs

@Divyajyothi7 Attached the updated workflow

RoundOFf_080623.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703