Hello there!
I need help, please
I have 2 table, like this
A b // Comparing date, column B does not have an specific order
1/7/2021 3/7/2019
2/7/2021 28/07/2019
3/7/2021 25/07/2019
A
1/1/2019 100
.
.
.
1/7/2021 100
2/7/2021 200
3/7/2021 300
So i want to sum 2 things,
(sum({<A={">=$(=date(min(A)))<=$(=date(Max(A)))"}>} VentaNeta84Sus) >> this works great
and i want to Sum the comparatives date (The same but using Column B)
(sum({<A={"$(B)"}>} VentaNeta84Sus) >> Something like this But i can not compare 2 columns
I tried also
sum({<DiaA= {"$(diaB)"},GestionA={$(#=ONLY(GestionB)-2)}>}VentaNeta84Sus) (As is the same month, The year is the actual one -2.. but comparing the days is not working also)
Thanks in advance
