5 Replies Latest reply on Dec 20, 2017 8:48 AM by Shinichiro Murakami

    Parameter mulitplying by 6

    Andrew Roberts

      Good afternoon,

       

      For some reasons my parameters are multiplying by 6 and not sure why?  Here is what I have

       

      EMP ID

      KPI

      Actuals

      YTD Goals

       

      I created a simple table:

       

      KPI
      ActualYTD Goals
      Projected Actuals

       

      I have created several Parameters:

       

      PLNBH

      BEP

      PRI

       

      Have a calculation that states:

          If [PLNBH] = 0 Then Actual

          Else [PLNBH]

          End

       

      I then use that in the Projected Actuals Calculation:

       

      If KPI = "PLNBH" Then [Parameter PLNBH]

      ElseIf KPI = "BEP" Then [Parameter BEP]

      End

       

      It works fine when I don't enter anything into the parameter.  However when I enter any number in the PLNBH Parameter it multiplies that by 6.  So 2 would become 12.

       

      I checked the data for number of records and nothing jumps out there.  There are not 6 records for x employee.  Any suggestions would be appreciated.  I have 9 Parameters so I also know that is not the issue.

       

      thanks,