cancel
Showing results for 
Search instead for 
Did you mean: 

Hierachy - Unit price - Node level

Former Member
0 Kudos

Hi Team ,

Requirement :
Responsibility Center ABC has two Level Upstream and Down stream.

The Revenue and UnitSold is at Responsibility Center at respective RC level ( Upstream and Downstream will have RC's )

Unit Price @ Upstream = Revenue @ Upstream / Volume Upstream

Unit Price @ Downstream = Revenue @ Downstream / Volume Downstream

so far so good - Issue is for calculation of Unit cost @ ABC node level .

System calculation Unit Price @ ABC = (Revenue @ Upstream + Revnue @ Downstream) /(Volume of Upstream+ Volume of Downstream)

Requirement is as below :

Unit Price @ ABC= (Revenue @ Upstream + Revnue @ Downstream) /(Volume of Upstream) - Downstream volume not to be considered in calculation .

Please let me know is it possible if yes how.

Regards,

Mandar

Accepted Solutions (0)

Answers (2)

Answers (2)

I051505
Advisor
Advisor
0 Kudos

Hello,

You have to create a new revenu type item to calculate your Unitprice @ ABC requirement.

Its revenue value should be equal to Revenue @ Upstream + Revnue @ Downstream and its volumes data should be equal to Volume of Upstream.

Take care,

thierrY

Former Member
0 Kudos

Hi Mandar,

Unit Price @ ABC level is a consolidation type not a formula, therefore what you trying to accomplish will not work as you have it setup.

Regards,

Athir