topic Rangesum() funktion with a specific year in App Development

Rangesum() funktion with a specific year

tim_m — Sun, 25 Mar 2018 09:23:18 GMT

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 — Sun, 25 Mar 2018 09:30:59 GMT

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 — Sun, 25 Mar 2018 16:02:48 GMT

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 — Mon, 26 Mar 2018 17:13:49 GMT

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

Anonymous — Mon, 26 Mar 2018 23:29:50 GMT

maybe try this...

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