Forum Discussion
Real example for Total:Expression in query
Hi guys, I would like to know how Total:Expression works in real life I can't find a real example. Can you give me a very simple example please?
And finally, here's a better example. This time a standard (non-crosstab) aggregate query showing an expression on the field Demerits:
isladogs thank you for your response. Now I understand. I've simplified the example. If we have a table of Employees like this:
and we need e.g. to calculate SUM of turnover with VAT for every project I can use the following query (with Expression):
That's it :).
- Glad you have a working solution
