Convert Table data to 1 decimal place

[danjohnsonM]

Hi

I am looking to have my table set out to be 1 decimal place if below 10, could someone please show me how to create a formula for the below data set without changing to string as the data i have in my actual data is about 5/6

Thanks Dan

[MichalM]

@danjohnsonM 

You can set the number of decimal places per column in the configuration of the table tool.

In order to introduce conditional formatting (use 1 decimal place only for values less than 10), you will need to create a column rulle

[danjohnsonM]

Hi

As the week number will be changing every week i cant set a specific rule for a specific column, would a row rule work?

[MichalM · Accepted solution]

@danjohnsonM 

With a row rule you'll also need to specify the individual columns. Instead, you will need to create a dynamic column rule using the Dynamic or Unknown Fields option. 

[_CurrentFieldName_] != "Type" OR ToNumber([_CurrentField_]) < 10 

[danjohnsonM]

I dont seem to get the option for decimals for my rows?

[MichalM]

It's the column rule rather than row rule.

[danjohnsonM]

As the week numbers are changing week on week i wouldn't be able to use this as i would have to go in manual and update rather than running on a weekly basis?

Any Ideas?

[MichalM]

@danjohnsonM 

You actually would as the Dynamic or Unknown fields option will apply the rule to any new column in your data set. Try renaming one of the columns and re-run the workflow - you'll be able to see for yourself.