14 Replies Latest reply: Jan 5, 2018 6:24 AM by pradosh thakur RSS

    Expression (Year(Today)) is ignored

    Tom Müller

      Dear all,

       

      coming off from this discussion I have a problem with the following expression:

       

      (Sum({$<Year={"(=Year(Today()))"}>}Kosten)+Sum({$<Year={"(=Year(Today()))"}>}Materialeinkauf))

      /(Sum({$<Year={"(=Year(Today()))"}>}[Erlös])+Sum({$<Year={"(=Year(Today()))"}>}Schlussrechnung))


      As far my knowledge goes, the "$" shall make shure, that just the period of the current year is considered. But it shows the value of the whole data. Furthermore I can change the expression (Year(Today)) to anything else, but nothing happens with the value. Any idea what I did wrong with my formula?


      Thanks in previous for the help.