2 Replies Latest reply on Apr 16, 2013 5:35 AM by Kelly Smolcynski

# How to: Price Variance

I'm hoping someone can help me with a Price Variance calculation I am trying to do.

I have the following in my sample data set (attached):

Products     Type     Supplier     Region     Year     Quarter     Document Date     Units     Invoice Amount  Price Variance

Apples     Fuji     Joe's Grocery     North     2012     1Q     1/1/2012     1616      \$2,185.60                   ???

Apples     Gala     Smith Farms     West     2012     1Q     1/2/2012     2230      \$6,500.69                   ???

Apples     Fuji     Smith Farms     East     2013     1Q     1/3/2013     2203      \$3,049.98                   ???

I would like to create a calculated field for Price Variance using the following:

Variance =(1Q13 Price-1Q12 Price)/1Q12 Units

What I cannot seem to figure out is how to not only calculate Price (Price = Invoice Value/Units); but also specify the year and quarter in my calculation.

I can use v7 or v8 - if that makes a difference.

kind regards,

Kelly

• ###### 1. Re: How to: Price Variance

I created a few table calculations base on your formula.  Take a look and see if it works for you.

1 of 1 people found this helpful
• ###### 2. Re: How to: Price Variance

Son -

Thank you so much!

Works perfectly.

I very much appreciate your help.

best regards,

Kelly