3 Replies Latest reply on Jul 2, 2015 3:46 AM by Quentin JUILLET

    calculating delta values

    Greg Araujo

      Hi there,

       

      I am trying to calculate delta values off min/max/aggregate values. Here's the dataset...

       

      report_typereport_monthnet_salesnew_net_sales
      actual01-Jan-13$100,000.00$99,000.00
      actual01-Feb-13$150,000.00$147,000.00
      actual01-Mar-13$200,000.00$147,000.00
      actual01-Apr-13$225,000.00$224,000.00
      forecast01-Jan-13$250,000.00$217,500.00
      forecast01-Feb-13$300,000.00$247,000.00
      forecast01-Mar-13$350,000.00$339,500.00
      forecast01-Apr-13$200,000.00$189,000.00

       

      and here's what i'm trying to do...

       

      actualforecastdelta
      start_net_sales100,000250,000-150,000
      net_sales450,000900,000-450,000
      new_net_sales393,000804,000-411,000

       

      any help is appreciated.

       

      thanks,

       

      greg