6 Replies Latest reply: Dec 23, 2013 11:21 PM by Rohit Koul RSS

    Ratios of Current vs Previous Years

      Hi All,

       

      I need to put in a formula which is the ratio of profits from the current year vs the previous year in a straight table for all underwriting years (which is the dimension in the straight table).

       

      My current formula looks like:

       

       

      Sum({$<PLR_PLY_TRANSACTIONTYPE = {'*'}-{'Q'},UnderwritingYear={'UnderwritingYear'}>}PLR_T_COYPREM) / Sum({$<PLR_PLY_TRANSACTIONTYPE = {'*'}-{'Q'},UnderwritingYear={'UnderwritingYear-1'}>}PLR_T_COYPREM)

       

      This however doesn't seem to be generating anything in my straight table except for a series of NULL values.

       

      I'm guessing there's something wrong with the syntax I'm using.

       

      Any help is appreciated.

       

      Regards,

      Nathan