Forum Discussion
Solved
sum columns between 2 dates
Hi all I've this table I need to have a column or a measure that sum for every "customer no" and between 2 dates selected, the columns with amount (SALDO).
Hi ryan_mayu
I've written too fast and I've make some error.
You must take the sum of fields SALDO after date 01/01/2023 and that is the "SALDO before" (I've wrong written "SALDO after").
"SALDO between" is the sum of all fileds "SALDO" between dates selected.
Hi ryan_mayu
yes this is, now I need also the column "SALDO before".
I've do it but I find a way only using the same query 2 times and I would find a way to have the new column with only a query, because it contains more than 700.000 records and the weight of file is very important 🙂 .
As you can see in picture below, I need also another column that contain the "same" of SALDO column (AVERE - DARE), but for all the records before the first date in selection....you are welcome