How to remove the AVG letter from the table?

Harry Sun
Harry Sun Customer, Community Captain
25 Up Votes 10 Comments Name Dropper 5 Likes
in Academy

Hi BOARD Team,

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

image.png

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

image.png

Tagged:

Accepted Answers

  • Samson Sunny
    Samson Sunny Employee, Community Captain
    25 Answers 100 Comments Third Anniversary 25 Likes
    Answer ✓

    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
    Marcus Smith Employee
    10 Comments Board Developer First Answer First Anniversary
    Answer ✓

    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]

    image.png

    I hope this helps!

    Thank you,

    Marcus Smith

Answers

  • Harry Sun
    Harry Sun Customer, Community Captain
    25 Up Votes 10 Comments Name Dropper 5 Likes

    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

Categories