revenue

Hi I have set up a macro to copy cell C3 from the 'Exports' tab to the next available cell in row F on the 'Revenue' tab starting in column 7. When I use it for the first and second times I get 'Run-time error 1004' however once there are at least two entries in the the receiving sheet (F7 and...

Hello, Hoping to get some much-needed help with some financial reporting automation. Table 1 is basically an input table. Upon receipt of quarterly financial statements, I enter revenue and EBITDA for the corresponding reporting period. Table 2 is my output summary.....this summary will...

Hi, Thank you in advance for helping. The company has a revenue sharing contract for 10% of the revenue starting when the company reaches $100,000 per month (month 7) in revenue until all $125,000 of the contracted amount of paid off (month 13) <tbody> Revenue <tbody> $20,947 </tbody>...

Hi guys, I understand that we do not have Calculated Fields in Power BI, so is there any way to emulate the function through adding new calculated columns in Power BI? Basically, the Calculated Field that I had back in excel is "(Target Revenue - Actual Revenue)/Actual Vol", referencing three...

Hi All, I am trying to build a cash flow forecasting tool. I have revenue that comes into a business on the nth day of certain months - this data is captured on the right hand side of the table below. in the data below as an example, on the (Dynamic Date) 1st of Jan thru Dec the revenue table...

I have months in columns from a table called dates_d. I want the revenue of the prior month, so I did calculate([rev],filter(all(dates_d),dates_d[date]>=edate(mina(dates_d),-1)&&dates_d[date]<edate(mina(dates_d),0))) Which works fine But then I do...

I have a very long list that I run a macro for. I need the total credit cards (Visa + Master Card + American Express) for that day. On top of that I am running a Macro and the date range is different every time. I think I need a formula that consolidates the "Date" Column so it doesn't repeat...

Hello, I am trying to create a model where a portion of revenue is consumed each month starting on the contract start date. The amount of consumption each month would be an input and could be changed if required. In the below example 85,000 is total revenue, 25,000 is consumed for 3 months. On...

Please see the table below for the cells referenced in my question...... Cell D1 is Data Validation from cells A1:A18 If cell D1 = Cell A2 then I need the value typed into cell E1 to contain the symbol in cell B2 $15 If cell D1 = Cell A7 then I need the value typed into cell E1 to contain the...

Hello, I need assistance creating a PY Revenue measure without a calendar table. Prior Year Revenue is the calculated measure I need to create. <tbody> Sales Year Revenue Account ID Prior Year Revenue 2017 $1234 11231 $36 2017 $123 213 $165 2017 $754 505 $1324 2017 $36 11231 0...

Full disclosure this is a cross-forum thread (excelgure.ca) since I need to find a solution quickly! https://www.excelguru.ca/forums/showthread.php?9263-Summing-area-of-data-across-multiple-tabs-with-multiple-criteria-array-and-indirect Hi Everyone, I'm spinning my wheels here between index...

<tbody> Level Name Industry ID Company Sector ID Sector Applicability ID Link Link Name Solution Name Prod 1 Prod 1 Rev Prod 2 Prod 2 Rev Prod 3 Prod 3 Rev Prod 4 Prod 4 Rev Prod 5 Prod 5 Rev Total Revenue by Row Revenue Split 1 Dairy Farms 43523 D43523 Dairy D43523Dairy (blank) 01-Dairy...

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D E F G H I </thead><tbody> 1 #FF0000[/URL] , align: center"]ID #FF0000[/URL] , align: center"]Stage #FF0000[/URL] , align: center"]Country #FF0000[/URL] , align...

I have a listing of all my products. One of the columns is called Sales Revenue. The next column is Gross Profit. I want to insert a data bar into the Sales Revenue column, but that value of the bar should reflect the corresponding Gross Profit, and not the Gross Revenue itself. Meaning, as if I...

Hi all, What I have is a relatively simple data set. I'd like to graph it so that the Revenue entries appear as clustered columns, and the Cash entries appear as markers right above (or inside) the corresponding revenue column. Using a combo graph, I'm able to get the columns and markers to...

Hey guys, hopefully someone can help before I get back into work tomorrow... I have a list of ~10 customers, each of which have a target revenue. For all 10 customers I have sales data going from 2013 to date (by month), along with month-to-date sales data for each month. I need to calculate...

There are 30 functions and each one is tied to revenue. So I know how much revenue is tied to each function. <tbody> Functions Revenue 1A $24.00 2A $54.00 3A $36.00 5A $23.00 8A $25.00 9A $42.00 11A $35.00 13A $75.00 1B $79.00 2B $6.00 3B $80.00 5B $7.00 6B $46.00...

There are 30 functions and each one is tied to revenue. So I know how much revenue is tied to each function. <tbody> Functions Revenue 1A $24.00 2A $54.00 3A $36.00 5A $23.00 8A $25.00 9A $42.00 11A $35.00 13A $75.00 1B $79.00 2B $6.00 3B $80.00 5B $7.00 6B $46.00...

Hi I have a large Excel file with price and revenue data for different products for different customers. Customer ID Product Revenue Jan Revenue Feb . ... ..... Joe´s pizza dough 10000 Joe´s pizza tomatos 42525 Joe´s pizza cheese 52525 . . . Sushi place...

Hi guys. My first post! I am trying to model multiple players entering a market with pre-defined probability. The portion that I cannot solve is starting a cash flow when the players enters the market and ends when the revenue reaches a certain level within a five year period. For example, the...