Aggregating a non-stored Calc field...

Classic Servoy
1

I have a non-stored calc field. Non-store because its part of a proprietary third party application table, and dont want to alter their solution, only augment it.

I cant seem to make an aggregate sum of this non-stored calc field. Its not showing up in the list of column selections in aggregates, however its integral to my solution and my presentation on Friday.

Any ideas how I can aggregate a non-stored calc?

Should I use a FOR loop in a method?

JM

2

Providence1:
I have a non-stored calc field. Non-store because its part of a proprietary third party application table, and dont want to alter their solution, only augment it.

I cant seem to make an aggregate sum of this non-stored calc field. Its not showing up in the list of column selections in aggregates, however its integral to my solution and my presentation on Friday.

Any ideas how I can aggregate a non-stored calc?

Should I use a FOR loop in a method?

JM

What about a SQL query?

3

for a non stored calc you need to do a for loop yes to do youre sum youreself.

Of if you can do the samething in a query as you do in the calc then a sql is also doable. But this depends greatly how big youre calc is and what it does.