Method Community

Hi Method,

Does anyone experienced in SQL? I'm looking for a function to subtotal the row post it on the bottom row. Just like to Subtotal Function in Method. But because I use SQL override, the Subtotal Function is not working. Does anyone know the SQL? Below are the screenshot,

Table

SQL Used

CONVERT(varchar, CAST([Amount] AS Money), 1) - As far as I know that this SQL works to make the Amount has Money format for thousand separator.

Please advise.

Hi Jonathan,

This isn’t going to work with the thousand separator. You are casting the value as a varchar and the subtotal function only works on a numerical field. Unfortunately, I am unaware of any workaround that you can use for this. If you need the subtotal field, you will need to remove the SQL override for the thousand separator. Sorry for the inconvenience.

-Audisho

Hi Audisho,

Noted on that. It might be a good upgrade for method to provide a thousand separator build-in in the table. So it has better visualisation.

Thank you for the info!

Hi Jonathan,

Thanks for the feedback. You’ll be happy to know that we’ve already included a thousand separator option on numerical fields in Method New. You just need to select the field in the screen designer and change the option to Yes. Hopefully this will come in handy for future projects. 

-Audisho