Rangesum() funktion with a specific year

[tim_m]

Hi Folks,

my Expression of rangesum looks like:

rangesum( above( sum(Sales),0,rowno())) and it works.

But I want to integrate the year information: When I change my expression in the following one, the datastream disappears and the chart is empty.

rangesum( above( sum({<year={"<=$(vActJahr) >=$(=$(vActJahr)-1)"},month={"=$(=vActMonat)"}>}Sales),0,rowno()))

What I am doing wrong?

Thanks a lot,
Tim

[Gysbert_Wassenaar]

Possibly this: month={"=$(=vActMonat)"}.

Try month={$(vActMonat)} or month={'$(vActMonat)'}

btw, if you limit month to one value you'll get only results for that one month. 

[tim_m]

Thank you for your suggestion. I thought it would work, but unfortunately not.

Can you explain me more detailed abut your btw... Do you mean I should deleate the month={"=$(=vActMonat)"} part?

[Gysbert_Wassenaar]

I'm pretty sure it won't do anything useful now. What do you expect it to do?

[Anonymous · Accepted solution]

maybe try this...

rangesum(above( sum({<year={">=$(=$(vActJahr)-1) <=$(=$(vActJahr))"},month={"=$(=vActMonat)"}>}Sales),0,rowno()))