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. [b]I give.[/b] Anything other than right align or plain {value} fails for me. Tried: {Value}$###,###.00 {Value},$###,###.00 {Value,$###,###.00} {Value},N {Value},n {Value},####,###.00 {Value}####,###.00 {Value,####,###.00} {Value}####,###.00 and [b]many[/b] others.

Try this....in the Presentation Column For SUM #= kendo.toString(sum, 'n') # For COUNT #= kendo.toString(count, 'n') #

Format Group field on query

BenchmarkDan

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:
{Value}$###,###.00
{Value},$###,###.00
{Value,$###,###.00}
{Value},N
{Value},n
{Value},####,###.00
{Value}####,###.00
{Value,####,###.00}
{Value}####,###.00
and many others.

Jaymer

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 support@awareim.com

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.

customaware

Try this....in the Presentation Column

For SUM
#= kendo.toString(sum, 'n') #

For COUNT
#= kendo.toString(count, 'n') #

BenchmarkDan

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.

$#= kendo.toString(sum, 'n') #

Looks good!

Jaymer

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.

BenchmarkDan

You got that right.

rocketman

WOW, this post just saved my life!!!

Here's another one I missed these past 9 years if anyone can help?. I've been changing a lot of my numeric attributes to be currency attributes, and utilising the Locale info to format UK customers with £ and Canadian customers with $ (only recently picked up some Canadian customers so it hasn't really been an issue until now - just me being lazy I guess)

All great except the report writer seems to totally ignore the locale data and just uses $

and ... does anyone have a similar solution for SUMming a duration attribute in a group. Vlad says it doesn't work and isn't meant to work, but I have no difficulty summing a duration at the bottom of a grid

rocketman

and in answer to my own question, this brilliant fix didn't work for totally group durations (but totalling the whole query works .... how strange)