This discussion is archived
0 Replies Latest reply: Oct 23, 2012 9:28 PM by Cypress RSS

How to achieve this OIC Calculation?

Cypress Newbie
Currently Being Moderated
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编辑过

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points