It appears that I can’t aggregate a non-stored calculation (but a stored calc is OK).
Any chance that this functionality will become available?
Alternatively, a work-around (that doesn’t involve storing the calculation!) would be appreciated.
Thanks,
Neale.
The reason you can’t aggregate an unstored calculation is that Servoy relies on your sql backend for aggregations (to offer the maximum performance). To aggregate an unstored caculation loop through your foundset or related foundset (you can loop through related data from the main form in Servoy)