Ratio Format

Hi,

How can I present the ratio in the following format?

D/E RATIO 0.00:1
NET D/E RATIO 0.00:1
INTEREST COVER 8x

Thank you.

Tags

Modeling

Calculation Functions

Accepted answers

Go to Blueprint ->Format and make changes as per below SS

For 1st & 2nd

For 3rd:

Output:

Hope that helps

Misbah

All comments

Go to Blueprint ->Format and make changes as per below SS

For 1st & 2nd

For 3rd:

Output:

Hope that helps

Misbah

Quick Links

Can you help?

Unanswered questions

ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…