3 Replies Latest reply on Apr 3, 2018 6:32 AM by Peter Hanges

    Allocating expenses across regions

    Peter Hanges

      Hi all,

       

      I have a database which shows the amount of expenses incurred by each region:

       

      Region
      Amount
      Americas$500,000
      EMEA$350,000
      APAC$200,000
      General$300,000

       

      I'd like to allocate 1/3 of the general expenses towards each Region, to produce a table like this:

       

      Region
      Amount
      Americas$600,000
      EMEA$450,000
      APAC$300,000

       

      Any ideas on how to do this?