Designer| Table properties - Decimal places

[Mj9715]

Hi All, I have hundreds of columns in my "table" and be default the decimal place is set to zero. Any way I can change the default or bulk change to 3 decimal places in the table without clicking on each column and changing manually?

[messi007]

@Mj9715,

You can use multi field formula 

Hope this helps,

Regards,

[Mj9715]

@messi007  I have already performed this, however irrespective of existing decimal places, the "table" tool changes the properties to zero decimal for all columns. My fix needs to be after the table tool is introduced. 

[Maskell_Rascal]

Hi @Mj9715 

Add you table tool to the canvas but make sure you don't connect it to anything to start. Once on canvas, click on the Dynamic or Unknown Fields option in the Per Column Configuration and then set your decimal places to three. 

Now connect your incoming data to the Table tool, and this will now automatically set any number fields to this format while leaving the string fields unchanged. 

Hope this helps.

Cheers!

Phil

[Kinetic_analytics]

Great help. Thanks

[apathetichell]

@Maskell_Rascal - this is the best solution I've read in months. Totally snoozed on it until now.

[cmtella245]

@Maskell_Rascal Kudos on this one - what an excellent solution!