Profit

Last step is to create a simple P&L hierarchy. All you need are these four nodes, link them to our appropriate submodels and join them using plus sign and you are done. Here are the formulas:

Nodefx
Profit

'Gross Profit' + 'OPEX'.'OPEX'

Gross Profit

'Revenue' + 'COGS'

Revenue

'Product'.'Revenue Product' + 'Service'.'Revenue Services'

COGS

'Product'.'COGS Product' + 'Service'.'COGS Services'


If you have done everything right, the final model should look like this:


As a last check, you can use the data preview button on the profit node to check if all of your formulas function the way they should:


Correct result

Country/Year 2018201920202021Totals
DEU14,869,422.4914,869,422.4914,869,422.4914,869,422.4959,477,689.97
FRA62,106,542.2562,106,542.2562,106,542.2562,106,542.25248,426,169.00
Total76,975,964.7476,975,964.7476,975,964.7476,975,964.74307,903,858.97


Congratulations

You are now able to create complex models on your own. We suggest you use your new model to create a workspace with 2-3 scenarios and few dashboards to understand the power of what you just created.

Good point to start learning about Workspaces is the Visualizing Data section of our documentation.