4 Replies Latest reply: Mar 26, 2018 7:29 PM by Antonio Carlos Bucher RSS

    Rangesum() funktion with a specific year

    Tim Müller

      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