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 #
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)
Grouping Calculations formatting
-
- Posts: 1476
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Grouping Calculations formatting
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>
<div style="text-align: right;"><b>Sub Total : #= kendo.toString(sum, '0.00') #</b></div>
-
- Posts: 1476
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya