TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Decimals on Averaging and Summary views
I Want to set the number of decimals displayed when a numeric column is set to show totals and averages.
And also in summary views.

Date Created
3/10/2022 2:22:01 AM
Date Updated
3/11/2022 5:16:11 AM
New Idea
Promoted By
Johannes RossouwJacquesJacques
DirkRhynoJacques du Plessis
Shaun Lamminga 3/10/2022 2:29:50 AM
This would be really helpful.
Pierre 3/10/2022 5:00:00 AM
If your number is defined as a "currency", you get a fixed number of decimals for your number and its aggregates (I think)
calvin peters 3/10/2022 10:21:01 AM
Maybe I misunderstand the problem but is this not controlled from SETUP for the NUMERIC COLUMN using the NUMERIC OPTIONS properties of the column?

Where DECIMAL PLACES can be set from 0 to 6 positions.
Pierre 3/10/2022 10:51:59 AM
I think that:
if your number is numeric (non currency), the number of decimals of the aggregates can be larger than the field setup.
if your number is currency, the number of decimals in the aggregate is exactly the number of decimals in the field setup. 3/10/2022 11:50:10 PM
Hi Pierre,

I have tested switching it to a currency and it definitely works, however it will only show 2 decimals (obviously), which really makes the view look a lot cleaner. I still think it will be good if there is a setting so set the decimals. In some cases for example with blueberry weight transaction we need to see it to 3 decimals.
But thank you it already makes a huge differences with the user experience.

@Calvin Peters, The column properties is already set to 3 decimals. Its when you set the column properties to show totals and averages where the problem comes in. See my original attachment as an example.
Pierre 3/11/2022 1:09:44 AM
Hello Marianne
You should be able to choose the number of decimals.
The "currency" type always displays the chosen number of decimals, even if it not necessary.
For instance, with three decimals
the number "1" will be displayed "1.000" (or "1,000" according to your selection for the decimal point).
This setting affects the field displayed as well as its aggregates.
Kind regards,
Pierre 3/11/2022 1:31:34 AM
If you need a variable number of decimals according to the nature of the record, you could also do the following:
- Create a text field (or a formula text field)
- Assign its content to something like If(<condition>, Format (Numeric field, "0.00"), Format(Numeric Field, "0.000"))
- Display this text field instead of your numeric field

Shaun Lamminga 3/11/2022 1:44:11 AM
Not gonna work in a summary view.
Shaun Lamminga 3/11/2022 1:45:27 AM
Text fields also do not total. 3/11/2022 1:54:33 AM
Talking about Summary Views Shaun,
Wouldn't it be great if you can sort the view (Descending or ascending) according to one of the columns being summarized?
Shaun Lamminga 3/11/2022 5:16:11 AM
@marianne This would be helpful.

The summary views are generally quite limited, being able to select and action a summary entry as a group of records would also be very useful, I can see it being challenging depending on volume.

I have mostly resorted to creating aggregate tables, linking relevant records to achieve more dexterity with "summarized" reports using table views.
Back to Search Results