If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#50324 by BenchmarkDan
Sun Feb 10, 2019 9:13 pm
Group field on a query. SUM function on a currency field. I cannot get a reasonable display.
I have spent hours - this is simple, surely even I can get this.

...Not so. I give. Anything other than right align or plain {value} fails for me.

Tried:
<p align="right">{Value}$###,###.00</p>
<p align="right">{Value},$###,###.00</p>
<p align="right">{Value,$###,###.00}</p>
<p align="right">{Value},N</p>
<p align="right">{Value},n</p>
<p align="right">{Value},####,###.00</p>
<p align="right">{Value}####,###.00</p>
<p align="right">{Value,####,###.00}</p>
{Value}####,###.00
and many others.
#50326 by Jaymer
Sun Feb 10, 2019 10:44 pm
yeah, you're spinning your wheels there.
pretty sure thats just an oversight - something that was never implemented (but can be) and has never been reported.
to be safe and be sure thats its seen, just write it up and send it as a bug to [email protected]

1) You can see the row data will respect a format (like $ #.##), yet the group total will ignore the formatting (as you've seen)
Easily doable by Vlad - so you'll just have to wait for that in a future build. No reason the Group {value} can't either:
a) allow for explicit formatting as you tried, or
b) as a minimum, just format it the same as the column data

2) In your tests, you prolly realize you can view the Server Output and see "invalid expression...." entries as you whittle away your time.
#50328 by eagles9999
Mon Feb 11, 2019 1:26 am
Try this....in the Presentation Column

For SUM
<span style="font-weight: bold; color: navy; float: right;">#= kendo.toString(sum, 'n') # </span>

For COUNT
<span style="font-weight: bold; color: red; float: right;">#= kendo.toString(count, 'n') # </span>
#50329 by BenchmarkDan
Mon Feb 11, 2019 3:36 pm
I agree Jaymer, this "should be there".

However, Mark your suggestion worked great. Thanks.

Added: font-size: 1.10em for a little size increase for the grouping total.
Added: a "$" -- although I thought I had seen that "$" might be trouble - but works here.

<span style="font-size: 1.10em; font-weight: bold;color: navy; float: right;">$#= kendo.toString(sum, 'n') # </span>

Looks good!
#50330 by Jaymer
Mon Feb 11, 2019 4:12 pm
BenchmarkDan wrote:I agree Jaymer, this "should be there".


this is great
all it needs is to actually be "in the product", not out on a forum somewhere, un-findable.
could easily be attached by support as a popup-help window and then anyone could do it.

Who is online

Users browsing this forum: No registered users and 14 guests