TeamDesk Knowledge Base & Support

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.
https://www.teamdesk.net/help/4.6.4.aspx

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.

marianne@farmtrace.co.za 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

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.

marianne@farmtrace.co.za 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.