Grouping Calculations formatting

If you think that something doesn't work in Aware IM post your message here
Post Reply
PointsWell
Posts: 1476
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Grouping Calculations formatting

Post by PointsWell »

If you group a query and then add Group Summaries to the grouping set these default to left alignment while the numeric attributes in the query above them are right aligned.

The group summaries need to also be right aligned and to capture the numeric format of the columns that they are summaries of, i.e. if the column format is #,##0.00 then the summary must be the same and not the default of #
Screenshot 2022-11-15 at 11.06.47.png
Screenshot 2022-11-15 at 11.06.47.png (15.28 KiB) Viewed 17144 times
It makes the group summary confusing and is inconsistent with the treatment of numbers (the summary can only be a number as you can't carry out numeric actions on a column of strings)
ACDC
Posts: 1158
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Grouping Calculations formatting

Post by ACDC »

insert this in the presentation section of the Group Summary setup
<div style="text-align: right;"><b>Sub Total : #= kendo.toString(sum, '0.00') #</b></div>
PointsWell
Posts: 1476
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Grouping Calculations formatting

Post by PointsWell »

ACDC wrote: Thu Nov 17, 2022 7:11 pm insert this in the presentation section of the Group Summary setup
<div style="text-align: right;"><b>Sub Total : #= kendo.toString(sum, '0.00') #</b></div>
Thank you!

Seems like that should all be add-able via the UI
Post Reply