2 Replies Latest reply on Nov 11, 2018 9:38 PM by Nilesh More

    Giving Targets to the calculated field

    Nilesh More

      HI,

       

      I need help with having targets against actual for a data table

       

      Parameters
      Targets
      Jan 18Feb 18Mar 18Apr 18May 18
      Frequency42%40%43%45%42%50%
      Severity7%9%5%4%8%3%
      Loss Ratio80%100%120%115%123%98%

       

       

      for the parameters are all calculated fields resulting in the months, need to have a fixed target column, with any inclusion or exclusion of the months columns.

       

      Regards,

      NiMo

        • 1. Re: Giving Targets to the calculated field
          Zhouyi Zhang

          Hi, Nilesh

           

          Is it possible to proivde a sample workbook and explain the expected result?

           

          ZZ

          • 2. Re: Giving Targets to the calculated field
            Nilesh More

            Hi ZZ,

             

            Thanks for responding, the data table above is the expected solution.

             

            I work with Insurance firm thus largely working on two data sets - Sales & Claims

             

            Calculated Fields as under -

            Frequency - Claims/Sales

            Severity - Claim Cost per Policy/Revenue per Policy

            Loss Ratio - Claim Cost/Revenue

             

            This data is maintained on weekly/monthly/yearly basis

             

            Each of the parameter has some target that needs to incorporated in the table even if the months move to latest, target needs to be frozen

             

            Parameters

            Targets

            Jan 18

            Feb 18

            Mar 18

            Apr 18

            May 18

            Frequency42%40%43%45%42%50%
            Severity7%9%5%4%8%3%
            Loss Ratio80%100%120%115%123%98%

             

            Hope I am able to paraphrase this.

             

            Thank you.

            Nilesh