2 Replies Latest reply on Mar 30, 2012 6:39 AM by Rick Dickens

    Sales as a percent of budget?

    Rick Dickens

      This seems like it should be SO easy, but I can't seem to figure out how to calculate sales as a percent of budget.  Hopefully I can describe this well, if not I'll attach something.  I've got a measure for "order sales" and a measure for "monthly budget", and I created a calculated field called BvA$ which is just [order sales]-[monthly budget].  I've got the date (year and month) for columns and a dimension (division) for the rows.  My measures are SUM(order sales), SUM(monthly budget) and SUM(BvA$) and that all works fine to give me the attached image.  But, I need to know how to calculate budget v actual % and add that in the next column.  It seems like it should be SO easy but I've been banging my head on the desk and searching the forums for 2 days.  Any help would be appreciated.

       

      Thanks!

        • 1. Re: Sales as a percent of budget?
          Tracy Rodgers

          Hi Rick,

           

          Create a calculated field that is the sum([Budget])/sum([Sales])

           

          Then, if you want to make this appear as a percentage, right click on the calculation, select Field Properties-->Number Format-->Percentage...

           

          Finally, add the calculation to the Measure Values card.

           

          If this doesn't help answer the question, would it be possible to post a packaged workbook (twbx file)?

           

          Hope this helps!

           

          -Tracy

          • 2. Re: Sales as a percent of budget?
            Rick Dickens

            That was it, except it's sales/budget but thanks SO much!.  I was doing the sales/budget, and when I put it on the card it said SUM(measurename) but I didn't realize I had to sum each measure in the formula.

             

            Worked a treat.

             

            Thanks!

            1 of 1 people found this helpful