0 Replies Latest reply on Oct 24, 2012 4:28 AM by Cypress

    How to achieve this OIC Calculation?

      Scenario likes this:

      Two dimensions:
      Dimension#1 Year Target Fulfillment Percentage
      Dimension#2 Discount (Selling Price/ List Price) for each transaction

      Ratetable is based on the two dimensions.

      So the formula is like this:

      Individually, no accumulative

      Input1: Year Target Fulfillment Percentage ( How to achieve this?)
      Input2: Discount (Easy to do)

      Is there anyone has any thought about it? The headache is when calculating the rate for each transactions (different discount), you need to know the whole year Target Fulfillment Percentage.

      帖子经 967311编辑过