budgets

  1. D

    A Newbie "How To" Question...

    Hi All, Brand new here and hoping you can help ;o) I have a simple weekly budgets spreadsheet that also tracks the actual sales values. What's the best way to recalculate the remaining budgets as the actuals come in? Basically, if the cummulative weekly actuals vs budgets are negative, take...
  2. T

    Calculating a new column to bring in budget amounts accounting for three fields

    I previously posed here with similar question, but wanted to be able to give a more indepth understanding of what my goal was. I have two tables from my erp system that is connected to power bi. One is actuals and the other is the budget. What i have been trying to do is to create a side by...
  3. D

    Automatically calculating remaining budgets with multiple criteria

    I have a spreadsheet with approximately 20 different tabs, each having a separate budget that is split into 3 sections. I've also got a master tab that I'm looking log all transactions/invoices related to any or all of the budgets on all the tabs. I would like to create a formula that...
  4. H

    Please can you help with "phasing"

    Hi Everyone I am trying to split a given number over a set number of months. Eg. If I had $30 and I wanted to split it over 5 months then I would have $6 per month. I'm trying to show this in different displays and I am looking for the values to change automatically if I change either the...

Some videos you may like

This Week's Hot Topics

Top