Formulas and reports

In the previous post, we showed how easy it is to use our handy tool called Aliases. But we are yet to talk about its coolest feature, formulas:

1. Formulas for metrics 2. Formulas for report

The first one is simple and clear. Using the same logic as before, we can create formulas with aliases followed by a dot and its metrics: (XYZ.DEBTCURRENT + XYZ.DEBTNONCURRENT)/XYZ.EBITDA.

The formula will be applied to each company under that alias.


Besides the above, it’s possible to write formulas for reports!

What if you want to get a report on companies at the time of their merge and compare that to a third one? Easy-peasy!

(Company1 + Company2; Company3) as XYZ



What to read next…

An easy way to compare metrics from several companies

OMG - It's ODM! (new search feature)

Calculate your own ratios!

Feedback plugin