- Joined
- Sep 30, 2022
- Messages
- 1
- Reaction score
- 0
hello, trying to calculate growth margin with formula below but not working please help!!!
SUM(INDEX((((total_revenue, MATCH(1, (ticker_symbol=Ticker_symbol2)*(years_list=year_2),0)/SUM(INDEX (total_revenue, MATCH(1, (ticker_symbol=Ticker_symbol2) *(years_list_list=year_1),0))-1)
SUM(INDEX((((total_revenue, MATCH(1, (ticker_symbol=Ticker_symbol2)*(years_list=year_2),0)/SUM(INDEX (total_revenue, MATCH(1, (ticker_symbol=Ticker_symbol2) *(years_list_list=year_1),0))-1)