+ Reply to Thread
Results 1 to 2 of 2

Calculate % variance on previous quarters. Quarter %, etc. pivot

  1. #1
    DaveC
    Guest

    Calculate % variance on previous quarters. Quarter %, etc. pivot

    How do I calculate a % variance from the previous quarterly total and place
    the % variance next to that particular quarter?

    Column qtr1 % qtr2 % qtr3 % qtr4 % Total$
    Row
    item1 50 ?? 75 ?? 100 ?? 125 ??

    Example: what is the % variance from qtr1 and qtr2? The variance per cent
    will go into the column format betwenn qtr1 and qtr2. Designated as ??.

  2. #2
    Registered User
    Join Date
    05-18-2005
    Posts
    60
    The best way to calculate qtr over qtr performance is the following.

    X = Previous Qtr Revenue
    Y = New Quarters Revenue

    The formula is:

    =(Y-X)\X

    So in your example for Q1 to Q2 revenue would be:

    =(75-50)/50 = 50%

    So the increase Qtr over Qtr was 50% You always devide (the difference from the new quarter to the old quarter) from the old quarter becuase that is the % you are looking for the delta from.

    HTH,

    PZan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1