# Trying to do a Budget to Actual

**URL:** <https://connect.superhuman.com/t/trying-to-do-a-budget-to-actual/1275>\
**Category:** Ask the Community\
**Created:** [June 26, 2018, 2:29pm UTC](https://connect.superhuman.com/t/trying-to-do-a-budget-to-actual/1275 "2018-06-26T14:29:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Sadowsky](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/david_sadowsky/32/1326_2.png) [@David\_Sadowsky](https://connect.superhuman.com/u/David_Sadowsky)\
**Post date:** [June 26, 2018, 2:29pm UTC](https://connect.superhuman.com/t/trying-to-do-a-budget-to-actual/1275/1 "2018-06-26T14:29:33Z")

</div>

Hi. I am a table of expenses and a table of set Budgets. Each entry on each table includes a “BannerCode” (from a Banner Table) and a “EventName” (From a Event Table).

I took a view of my Budget table and filtered it by a specific Event I would select on the top of the page. This works great as I see the budget for that particular Event. Now I want to add a column to this view that also shows the expenses.

Here is what I have so far:  
 ![image](https://global.discourse-cdn.com/coda1/original/2X/2/2f1cce8f7d02e7e8eee66c57e02a7b74130b4c2f.png)

The formula for the Amount right now is =Expenses.filter(Event=SelectedEvent).Amount.Sum()

So I’m getting the total expenses (I entered 125 as a test). But what I need is to actual sum by the Banner code on the left of the table. Usually I would use a SumIf in excel but I can’t seem to get that to work.

---

<div class="post-metadata">

**Author:** ![mallika](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/mallika/32/12981_2.png) [@mallika](https://connect.superhuman.com/u/mallika)\
**Post date:** [June 26, 2018, 9:28pm UTC](https://connect.superhuman.com/t/trying-to-do-a-budget-to-actual/1275/2 "2018-06-26T21:28:20Z")

</div>

Would something like this work -

[![](https://d2ddoduugvun08.cloudfront.net/items/1v3F45392t2e041y1N3G/Image%202018-06-26%20at%202.26.44%20PM.png) ](https://d2ddoduugvun08.cloudfront.net/items/1v3F45392t2e041y1N3G/Image%202018-06-26%20at%202.26.44%20PM.png)

---

<div class="post-metadata">

**Author:** ![David\_Sadowsky](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/david_sadowsky/32/1326_2.png) [@David\_Sadowsky](https://connect.superhuman.com/u/David_Sadowsky)\
**Post date:** [June 27, 2018, 2:05pm UTC](https://connect.superhuman.com/t/trying-to-do-a-budget-to-actual/1275/3 "2018-06-27T14:05:30Z")

</div>

Hi,

I copied that formula to my Budget to Actual table and all the amounts turned into the word true.

---

<div class="post-metadata">

**Author:** ![mallika](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/mallika/32/12981_2.png) [@mallika](https://connect.superhuman.com/u/mallika)\
**Post date:** [June 27, 2018, 6:51pm UTC](https://connect.superhuman.com/t/trying-to-do-a-budget-to-actual/1275/4 "2018-06-27T18:51:21Z")

</div>

Oh, it was supposed to be a Filter on the table on a formula in the column.

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [November 2, 2021, 11:20pm UTC](https://connect.superhuman.com/t/trying-to-do-a-budget-to-actual/1275/5 "2021-11-02T23:20:39Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.