Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
maybe try this...
rangesum(above( sum({<year={">=$(=$(vActJahr)-1) <=$(=$(vActJahr))"},month={"=$(=vActMonat)"}>}Sales),0,rowno()))
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.
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?
I'm pretty sure it won't do anything useful now. What do you expect it to do?
maybe try this...
rangesum(above( sum({<year={">=$(=$(vActJahr)-1) <=$(=$(vActJahr))"},month={"=$(=vActMonat)"}>}Sales),0,rowno()))