Percentage Revenue Distribution RevenueCALCULATE sum Revenue Distribution RevenueALLSELECTED 100. Calculate a percent distribution you can use a formula that simply divides an amount by the total. Next move on to your variable expenses.
Then determine if you can reduce any of those expenses to bring that percentage down.
Verify your formula is correct and you are able to save the new column. Calculate your expenses for the same period of time for which you collect sales data. If you divide 700 by your monthly income of 3000 youll get 233percent. You want to create a budget and you need to know what percentage of your income goes to eating out every month.