Former Member

# Hierachy - Unit price - Node level

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

10|10000 characters needed characters exceeded

### Related questions

• Former Member
Posted on May 12, 2015 at 07:40 PM

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

10|10000 characters needed characters exceeded
• Posted on May 18, 2015 at 09:51 AM

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