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.

Example

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

XYZ.DEBTC_MRQ+XYZ.DEBTNC_MRQ

Example

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