|
| Inicio → WINDEV 2024 → Problem with aggregate functions and formula in the query editor (WinDev14) |
| Problem with aggregate functions and formula in the query editor (WinDev14) |
| Iniciado por jacek.jurkowski, 04,jun. 2017 21:32 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 04,junio 2017 - 21:32 |
Hi,
I need to:
1. Get some rows that are between the given dates
2. Calculate SUM on two columns with GROUP BY
3. Subtract these sums and put the result in a new column
It seems that I need 3 queries taking data from one another, in a row when I want to use query editor:
A. Query1: select rows between the dates
B. Query2: do the sums
C. Query3: select the sums and make a formula using sums
But I couldn't make query from query from a query work. Only query from a query is possible.
Any suggestions how to go around it in the query editor ?
Thanks in advance
/Jacek |
| |
| |
| | | |
|
| | | | |
| | |
|