0 Replies Latest reply: Oct 23, 2012 11:28 PM by Cypress RSS

    How to achieve this OIC Calculation?

    Cypress
      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编辑过