How to remove the AVG letter from the table?

Harry Sun · 2024-03-16T06:54:29+00:00

There was an error rendering this rich post.

Hi BOARD Team,

Under Configure Layout, I calculated a data block by using Average.

In the table, it will always show the AVG at the front. Anyway I can remove the AVG letter from the table. I only want to display the number, but not those letters. Thanks

Find more posts tagged with

Layout

Accepted answers

Samson Sunny

Hi @Harry Sun,

This is as per design. Selecting any summary other than "Total" or "No Total" returns the selected summary abbreviation in front of the value as it aids in identifying and differentiating from the default "Total" summary value.

You can raise this as an idea in the community for it to be considered as an improvement

Marcus Smith

Hi @Harry Sun,

Can you please try this if it works for you? The current version I've is 12.6 where it is useful.

Screen design mode > select the cell where AVG appears > COLUMNS (right-pane) > select 'Ignore Format Template'.

[Screenshot pasted below for your reference]

I hope this helps!

Thank you,

Marcus Smith

All comments

Samson Sunny

Hi @Harry Sun,

You can raise this as an idea in the community for it to be considered as an improvement

Marcus Smith

Hi @Harry Sun,

Can you please try this if it works for you? The current version I've is 12.6 where it is useful.

Screen design mode > select the cell where AVG appears > COLUMNS (right-pane) > select 'Ignore Format Template'.

[Screenshot pasted below for your reference]

I hope this helps!

Thank you,

Marcus Smith

Harry Sun

I am working on V12.3. So this Ignore format template checkbox is not available. But we will update our BOARD soon.

Thanks a lot for your feedback