Hello everybody,
how can i manipulate an Excel List. I have a original table with data inside. I saved formulas as variable. My Goal ist to save the solution of the formulas in a new Excel list (calculated table)
Original table
| figures | € |
|---|
| Revenue I | 1 |
| Revenue II | 2 |
| Cost I | 4 |
| Cost II | 5 |
Here you see my formulas in the LOAD:
Sum ([Revenue I + II]) = sum(if(figure='Revenue I') + sum(if(figure='Revenue II')
Sum([Cost I + II]) = sum(if(figure='Cost I') + sum(if(figure='Cost II')
Div([Cost/Revenue]) = $(Sum([Revenue I + II])/$(Sum([Cost I + II])
Calculated table
| figures | € |
|---|
| Revenue I | 1 |
| Revenue II | 2 |
| Sum(Revenue I+II) | 3 |
| Cost I | 4 |
| Cost II | 5 |
| Sum(Cost I +II) | 9 |
| Div([Cost/Revenue]) | 3 |
I hope someone understand my Problem and know how to solve this Problem.
Thanks.
