4 Replies Latest reply: May 16, 2017 6:06 AM by omar bensalem RSS

    Question

    Saran Wanjiru

      Hi,

      I have a data set with two fields i.e the Budget and amount spent from the budget. i need to calculate the percentage of the total expenditure. how do I create the function.

        

      Actual Budget - Combined   Consumed Budget                                                                      Combined
      $32,500.00           
      $1,140.00
      $192,708.00
      ($99.69)($99.69)
      $48,853.78 $16,353.78
      $325.00 $325.00
      $935.38 $935.38
      $8,765.37 $8,765.37
      $206,579.83 $207,332.13
      $13,330.51 $13,330.51
      $0.00 $0.00
      $100,000.00
      ($96,354.00)
      $0.00 $0.00
      ($56.00)($56.00)
      $99.69 $99.69
      ($1.71)($1.71)
      $98.56 $98.56
      ($6.96)($6.96)
      $27,162.03 $27,162.03