Show column sum function?

[d.smith]

Hi,
Before I ask a question I would like to say thanks to Ahmad for a great product. I used to use Appgini many years ago and wrote a small testimonial to acknowledge my support for the program and am now back and have purchased the new version to begin using it once again..

My question is related to the Show Column Sum function. I have noticed in the Simple Invoicing sample this function is used to create sums providing the totals for certain fields? I don't however understand how to use it to do this? I have used F1 to read the help on the function but still am lost as what to do to make use of it? I have several fields I would like to add together to provide a total value but am stuck.

Any help would be most appreciated.

Thanks in advance.
Dave.

[a.gneady]

Thanks for your feedback.

The sum function provided by AppGini can show the sum of a single field across multiple records but can't currently be used to calculate the sum of multiple fields ... to apply it, select a numeric field in AppGini and check the option labeled "Show column sum" ... that's all you need to do to use it.

[AhmedBR]

The sum is a very good function and I am using it a LOT, but found one problem:
If the fields are lookups the sum would add the IDs instead of the real values!

[a.gneady]

I have this bug on my to-do list for fixing in a future release (not the next one unfortunately)

[d.smith]

The sum function provided by AppGini can show the sum of a single field across multiple records but can't currently be used to calculate the sum of multiple fields ... to apply it, select a numeric field in AppGini and check the option labeled "Show column sum" ... that's all you need to do to use it.

Thank you for that explanation.

[johnboy]

The sum is a very good function and I am using it a LOT, but found one problem:
If the fields are lookups the sum would add the IDs instead of the real values!

Hi,

Any update on fixing this bug?


Thanks


John

[a.gneady]

Not yet unfortunately ... but here is a starting point if you want to fix it manually for now: In the generated "tablename_view.php" file (where tablename is the name of the concerned table), find the line starting with

Code: Select all

$sumQuery=

and edit the query in there to sum the parent field rather than the lookup field.