8 Replies Latest reply on Jul 24, 2015 9:41 AM by Ryan Ray

    calculate this?

    Ryan Ray

      Hello All,

       

      There are two metrics: metricA and metricB. Please see the attached file

      User can choose two dates – start date, end date

      I want to create a calculated filed that does this:

      Let’s say if my start date is 2/1 and end date is 2/6, I would need to do the following

      Sum of MetricB (from 2/1 through 2/5) – sum of metricA (from 2/1 through 2/5)

      So the formula will show:

      (1+3+7) – (2+4+5) = 0

       

      So, I sum up both the metrics till the day < than the end date given by user