Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
use below code
sum({$<Mese = {"<=$(=Mese)"}>} Quantita)
hope this helps
unfortunately it doesn't work, the problem is that I need to sum all the values where the date is smaller then the selected date. if I use = is not correct, would be < but I think that can't use logic operator in this kind of string.....
If I insert the code in my test file (attached) the result is 30 instead 26 futhermore if I select some days it dosen't work
...any other idea ?
thx in advance
Sabina
You'll need to convert the Date into Date in your script and then use it in the set analysis. As far as using Months is concerned: you can try: Sum({$<Mese = {'<=$(=max(Mese))'}>}Quantita)
I have already found a part of the solution...I mean If I use this
Sum({$<[Data] = {"<=$(=Date(num(min(Data))-1))"}>} Quantita)
when I select some values in the Data field, it's work corectly...
but If I select month or year the previus code doesn't work... the problem is that I don't know which fields the user want to use...
Thx again
Sabina