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!
1 of 1 people found this helpful
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.