5 Replies Latest reply on Nov 8, 2016 8:43 AM by Sherzodbek Ibragimov

# Try to calculate price keeping one item within a dimension 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: Try to calculate price keeping one item within a dimension constant

Todd,

Hope I understood you correctly. See below:

• ###### 2. Re: Try to calculate price keeping one item within a dimension constant

Sherzodbek,

Thanks for your help, but I do not see the attached twb file.  Looking at the screen shot I think your solution may work.

Thanks,

Todd

• ###### 3. Re: Try to calculate price keeping one item within a dimension constant

Todd,

It is attached to my previous reply as seen below:

• ###### 4. Re: Try to calculate price keeping one item within a dimension constant

Sherzodbek,

thanks for the help.  using a copy of the gas table and using the Henry price was an effective way.

Todd

• ###### 5. Re: Try to calculate price keeping one item within a dimension constant

Todd,

I am glad it helped to solve your problem. If so, can you please mark it as correct answer so that it is cleared from question board that need to be answered and other users can benefit from it. Thank you

Sherzod