3 Replies Latest reply: May 23, 2018 3:31 PM by CARL CIMINO RSS

    Multiply across Rows

    CARL CIMINO

      Trying to multiply the Rate Change where Data Type = RATE to the Statutory Written Premium where data type = STAT by Year.  The Dollar Change results below the data are what I get in excel.  Any help would be appreciated.

          

      YearRate ChangeStatutory Written PremiumData Type
      2010-0.013$0RATE
      20120.056$0RATE
      20130.086$0RATE
      20140$0RATE
      20140.04$0RATE
      2015-0.008$0RATE
      20160.03$0RATE
      2009-$112,404,000STAT
      2010-$114,932,000STAT
      2011-$119,944,000STAT
      2012-$127,579,000STAT
      2013-$135,964,000STAT
      2014-$143,446,000STAT
      2015-$147,480,000STAT
      2016-$148,946,797STAT
      Dollar Change
      2009 -  
      2010 (1,494,116)
      2011 6,716,864
      2012 10,971,794
      2013 -  
      2014 5,737,840
      2015 (1,179,840)
      2016 4,468,404