How to remove the AVG letter from the table?

Harry Sun
Harry Sun Customer, Community Captain
10 Comments 5 Likes Community Captain Photogenic

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

Tagged:

Accepted Answers

  • Samson Sunny
    Samson Sunny Employee, Community Captain
    100 Comments Third Anniversary 25 Likes 5 Answers
    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
    First Answer First Anniversary 5 Up Votes Level 100: Foundations of Building in Board
    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]

    I hope this helps!

    Thank you,

    Marcus Smith

Answers

  • Harry Sun
    Harry Sun Customer, Community Captain
    10 Comments 5 Likes Community Captain Photogenic

    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