3 Replies Latest reply on Nov 7, 2016 6:54 AM by Todd DeCook

# Calculate price between two dimensions points keeping one constant

I am trying to calculate a natural gas price based on two dimensions.  The first dimension is Henry Hub which is the base price (measure) which I subtract a regional basis gas price from to get my final price.  Henry Hub never changes, but I want the user to be able to filter through all possible dimensions for various prices.

example

various pricing hubs (dimension) and price (measure) include:

malin \$.01

socal -\$.20

henry \$2.00

I want to calulate the price of socal gas which would be henry + socal (\$2.00 + (-.20))=\$1.80

Henry will always be used, but the user can calculate a new gas price by selecting different dimensions in the filter.

From here I would like to make a calculation with this new gas price for by taking a power price / calculated user specific gas price.

I have included an example.

Thanks

Todd

• ###### 1. Re: Calculate a price when one dimension remains static while the another is changed by user.

Hi Todd,

Just to start the journey;)

Not sure what you are aiming for but find my approach as reference below and stored in attached workbook version 9.3

• ###### 2. Re: Calculate a price when one dimension remains static while the another is changed by user.

Hi Todd,

Here's a link that you might want to consider:

Hope this helps.

Don

• ###### 3. Re: Calculate a price when one dimension remains static while the another is changed by user.

...or maybe you can just add 'henry' as a column to your data, set at \$2.00:

just add the 'Final Price' calculation as:

[Henry]+[Price]

Don