PDA

View Full Version : Functions on groups.



Michael Mullan
21-Feb-2010, 02:37 PM
I have a group on Month, with a field for Sum of Sessions which is a count, and a sum of fees paid.

It does not seem possible to get the average fee per session. Am I missing something, or is this YAFR?

[edit]
I have since tried adding a function which uses the given field names of the "sum of" fields, but they always evaluate to Zero.



return ((({Sum of rptDaily.InsFee})/(CDbl({Sum of rptDaily.CF})))


[edit]

MM.

Michael Mullan
7-Mar-2013, 10:57 AM
I really need this now.

Todays exercise in futility is a Cross Check report, sum up amount of Open Balances on each customers invoice headers, match to customer's balance. if both are equal, hide.

Grr I have to make a manual Sum function, and reset it correctly, would be much more betterer if the internal function totals appeared under "Report Fields:" in the treeview on the top left of the function editor.

Is this in the 3.0 Release Prospect?

Vincent Oorsprong
8-Mar-2013, 02:17 AM
Michael,

No access to sum's yet but the product is not ready for beta either.

Michael Mullan
8-Mar-2013, 09:59 AM
:-(

John Sutton
12-Mar-2013, 12:44 PM
I did this very thing, had over 160 sums and functions...

This seems like a very basic function that would be added SOON!