Changing decimal places of multiple fields at one go in Reporting

[RajatRehria]

Hi Team,

Kindly help if there is any wayout to change the decimal places of multiple columns together in reporting of the table as my data has 100+ numeric columns. Thanks.

[PanPP]

Hi @RajatRehria 

Are you trying to change the columns to a decimal data type to show 2 places after the decimal? 

I have provided a sample WF to convert all columns to a fixeddecimal data type.

[Felipe_Ribeir0 · Accepted solution]

Hi @RajatRehria 

For the report table, try this trick:

1)place a new table tool on canvas without connecting it

2)change the decimals for the Dynamic or unknown fields

3)connect the dataset to the table tool

[IraWatt]

Hey @RajatRehria,

Would you be able to give any exmaple data? One way of doing this is with the multi field formula:

This way you can select all numeric fields and assign them to a fix decimal with a specific decimal places.

[RajatRehria]

Hi Pan,

Thanks for the quick response.

Actually i want to render my report and using Table tool for that and if i want to display the decimals places e.g. 3 then I have to make adjustment in the Table tool by increasing the decimal places (refer screenshot). I would have done if it was for fewer columns but my report has 100+ numeric column and increasing each column decimal places in the Table tool is so much of work and thats why I am looking if there is any easier way to do that.

[RajatRehria]

Many thanks Felipe, your solution resolved my issue. Appreciate for the quick solution.