# Actual vs Forecast revenue question **URL:** \ **Category:** Ask for Help\ **Created:** [March 7, 2023, 2:30pm UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879 "2023-03-07T14:30:58Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [March 7, 2023, 2:30pm UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/1 "2023-03-07T14:30:58Z")
How can I calculate an actual revenue (based on events in the past) and a forecast revenue (based on events in the future) ? Thanks for your support ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 7, 2023, 2:47pm UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/2 "2023-03-07T14:47:19Z")
- Actual Revenue: would be a sum of sales, yes? Assuming that you are recording sales in a table, then you can use a rollup column to sum all the amounts. - Forecast Revenue: how would you calculate this if you were to do it manually? ---
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [March 7, 2023, 5:39pm UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/3 "2023-03-07T17:39:43Z")
Hello Daren actual = sum of sales up to today forecast = sum of sales coming in the future (assuming I have a date for each event) ---
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [March 15, 2023, 7:05pm UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/4 "2023-03-15T19:05:11Z")
Dear Daren Have you any tips to cover my request? Basically I record events and split the revenue by participants I need to report on events and revenue older then today and also report on events and revenue planned in the future Hope my explanations are clear Thank you ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 16, 2023, 1:22am UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/5 "2023-03-16T01:22:41Z")
Can you show us a sample of how your data looks like? ---
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [March 16, 2023, 2:39pm UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/6 "2023-03-16T14:39:54Z")
[data set](https://drive.google.com/file/d/1RvaZTgpLzsfV7khcx7L9cAcf34K5y8aM/view?usp=sharing) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 17, 2023, 12:32am UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/7 "2023-03-17T00:32:58Z")
Please allow access to thinh@lowcode.agency. Thank you. ---
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [March 17, 2023, 6:13am UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/8 "2023-03-17T06:13:11Z")
Done ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 17, 2023, 2:17pm UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/9 "2023-03-17T14:17:18Z")
Which table in the file should I take a look at? And which columns are you using to reference the revenue? ---
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [March 19, 2023, 6:44am UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/10 "2023-03-19T06:44:24Z")
Shows table : “Date for the show” Zicos : “Tip for the zicos” (musician revenue for a specific show) MyBalance : dashboard for actual revenue vs forecast (sum of credit vs sum of debits) MyDebs : store all debits made by a musician actual revenue = sum of all the “Tip for the show” for a musician participating to a show (“Participant”) up to now forecast = sum of all the “Tip for the show” for a musician assigned to a show (“Participant”) planned in the future (based on date for the show) ---
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [March 29, 2023, 2:52pm UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/11 "2023-03-29T14:52:07Z")
Hi Experts, I guess I need to filter the result of a Rollup field based on dates… can this be done? thanks ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 30, 2023, 2:00am UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/12 "2023-03-30T02:00:09Z")
In the Zicos table, how do you know which show is the tip for or does it not matter? Do those tips for a specific musician or for all musicians and then you divide them later? ---
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [March 30, 2023, 7:23am UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/13 "2023-03-30T07:23:32Z")
In Zicos, “Shows Participation ID” relate to Shows table “row ID”. Tips are recorded for specific musicians. ---
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [April 6, 2023, 7:31am UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/14 "2023-04-06T07:31:06Z")
😭 😭 😭 😭 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 6, 2023, 11:10pm UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/15 "2023-04-06T23:10:44Z")
Assuming rows in Users are musicians you want to calculate the revenue for. Step 1: In Shows, create an If-Then-Else column: “Future?”. If “Date for the Show” is after now then true, else false. Step 2: In Zicos, create a lookup table using the “Shows Participation ID” (I would recommend renaming this to Shows ID, it’s the ID of the show and adding the word ‘participation’ in there would be confusing) back to the Shows table. Step 3: Use a lookup column to pull the “Future?” column into the “Zicos” table. Step 4: In the “Zicos” table, create an “Actual Revenue” column. If “Future?” is checked then 0, else return the “Tip for the Zicos” value. Step 5: In the “Zicos” table, create a “Future Revenue” column. If “Future?” is checked then return the “Tip for the Zicos” value, else return 0. Step 6: In the Users table, create a relation using the name of the user to the “Participant” column in the “Zicos” table (though this is not recommended, you should store the rowID of the user in the “Zicos” table and use that for the relation instead of the name, which may not be unique). Make it a multiple relation. Step 7: Create a rollup on top of the relation, sum the “Actual Revenue” column. This will be the sum of actual revenue for the musician. Step 8: Create a rollup on top of the relation, sum the “Future Revenue” column. This will be the sum of future revenue for the musician. ---
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [April 7, 2023, 6:31am UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/16 "2023-04-07T06:31:38Z")
Thank you very much for the tips, I will give a try Cheers ---
**Author:** ![Le\_Paco](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/le_paco/32/55379_2.png) [@Le\_Paco](https://community.glideapps.com/u/Le_Paco)\ **Post date:** [April 7, 2023, 11:09pm UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/17 "2023-04-07T23:09:21Z")
You are my Hero !!! 🎖 🏆 🏅 Thank you so much for your support and patience Cheers ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 8, 2023, 12:36am UTC](https://community.glideapps.com/t/actual-vs-forecast-revenue-question/58879/18 "2023-04-08T00:36:52Z")
So it worked! Good to hear.