eagles9999 wrote
Why not just use a Number format of n instead of # ?
I've tried what I think you mean but it doesn't seem to do anything either. I think I might be misunderstanding how this is meant to work so I will supply some snippets to hopefully help convey what the problem is.
The last thing I tried was making a new query, changed it to display as a custom HTML query and placed a line like this in it:
{Budget}
I then tried to modify the formatting with kendo.toString() to remove unneeded precision of the number in a user dashboard for ease of review (no need to know the number to 10 decimal places when you are just checking things for a rough idea of the situation, you can view it in full elsewhere). To do this I tried putting the toString() function in script tags in the hopes it would just display the output but that unfortunately didn't help.
I ended up putting the attribute inside a class that looks something like this:
<div class="kendoBudget">{Budget}</div>
Then tried using an initialisation script (and later a render script) to grab all HTML elements with the "kendoBudget" class to use the innerhtml's current content as input for the toString() function then replacing the innerhtml of each element with the result of the toString() function. This didn't work either and even if it did would involve a lot of loops on a large number of objects that I would rather avoid if possible. I did however manage to get this idea to halfway work by assigning a span with an id then doing the same thing to that span. The problem with this is that ids can only be used once in HTML and therefore I was only able to modify the first line of the query, not all of them.
I think at some point I may have overcomplicated this whole thing but I really don't know. I have tried using a javascript alert to tell me how many elements with the class on them are in the html but the response back is always 0 which is confusing too since there should be hundreds if not thousands of records with that class attached to them (afterall I can read the original number in the query).
I just want a number like "123456.789" that is saved in an attribute at that precision to be displayed in a Custom HTML query as "123,456.79".
