Forum Discussion
DiePic
3 years agoResolver II
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).
- 3 years ago
Pls check if this is what you want
ryan_mayu
3 years agoSuper User
Pls check if this is what you want
DiePic
3 years agoResolver II
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....
- ryan_mayu3 years agoSuper User
you are welcome