Re: Formatting query parameters

[asgallant]

I'm not sure what to do to make that work, but you can skip trying to format in the query and format in JS instead, using a NumberFormatter.

On Thursday, June 21, 2012 10:04:19 AM UTC-4, Raul Marengo Lopez wrote:

hi there, 

I have the following query:

query.setQuery('SELECT A, avg(F) group by A ' );

And I would like to format avg(F) to have no decimal point.

I am trying: 

SELECT A, avg(F) group by A format F '#'

But this results in an invalid column [F] error.

I have tried "format avg(F) '#'" but that shows the same error and I haven't been able to find the actual syntax for calculated fields in the documentation. 

Any help is appreciated.

Thanks!

[Raul Marengo Lopez]

Awesome, that's worked for me.

Thanks for your help.