Method:Classic General Q&A

Re: Sum of a grid row

Method_Michael — Tue, 29 Mar 2011 16:19:05 GMT

Hi Greg,

You don’t actually have to put "SELECT Jan, Feb" you can just type in a field name in the box for example you can just type in RecordID and it will print the RecordID in the column. If you take a look at some of the grids on our Mobile screens you can see this in action. One thing to note is if you are adding numbers together instead of concatenating strings you may have to include checks for null values and do some casting. If the grid doesn't show up it means that there is something wrong with the script you entered.

If you get stuck on this or need further help you can schedule some paid consulting time with me and we can go over this together.

-Michael

Re: Sum of a grid row

SpaScapes — Tue, 29 Mar 2011 15:10:20 GMT

Hi Michael,

Whenever I put ANY SQL into the SQL Override of my Total column, the grid does not display. I tried just putting "SELECT Jan, Feb" which shouldn't even really do anything but the grid is hidden. When I remove the SQL the grid reappears.

Any ideas?

Re: Sum of a grid row

Method_Michael — Tue, 29 Mar 2011 13:54:21 GMT

Hi Greg,

This can be achieved using SQL Overrides. The webinar HERE goes over SQL overrides in Method grids.

-Michael

Sum of a grid row

SpaScapes — Tue, 29 Mar 2011 01:49:13 GMT

Hello,

I've created a grid for monthly expense items. The first column is the item, followed by 12 columns for the 12 months. I would like to sum the total of each month into the last column.

I've noticed there is a 'Get Sum' action, but this only sums up columns. Is there a way to sum vales in the same row?

Thanks,

Greg