5 Replies Latest reply: Mar 30, 2017 11:32 AM by Stefan Wühl RSS

    using function in set analysis

    Eli Karp

      Hi all,

       

      I'm trying to use the year function within set analysis.

       

      Sum({<year([Purchase Creation Date]))>='($(vPrevYear)}>} [Field I want to sum])

       

      Its not recognizing the function for some reason. I cant hook it up to the master calendar year because I need this specific year the master calendar is hooked up to a different field. Is there an easy way to do this without creating a whole separate field on the load script?

       

      Thanks!