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.
#52136 by rocketman
Thu Nov 21, 2019 1:34 am
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
#52141 by rocketman
Thu Nov 21, 2019 1:48 pm
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)

Who is online

Users browsing this forum: Google [Bot], MSN [Bot], Rem and 24 guests