6 Replies Latest reply: Jan 12, 2015 10:30 AM by Stefan Hofmann RSS

    Compare dates in Set Analysis

    Stefan Hofmann

      Hi all,

       

      have a problem with a chart where I want to show turnover by date (Year) relating to the Year when first turnover has been created. My chart should show for 2014 total turnover for all parts with first turnover in 2014, same for 2013...

      I have created a calendar for the turnover date and selected the min turnover date to find out when the first turnover happened. Both dated are formatted to YEAR.

      In the chart I use the following Set Analysis function but do not get any result:

       

      sum({$<FirstTO_Year={"$(=Year)"}>}(Value))

       

      Any ideas ???

       

      Thanks