Ratio format 5:1

[carojvi]

Hello,

Is it possible to have a formula that would result in something looking like 5:1 instead of 20%?

I have 2 numeric fields, and I want the 3rd to show the ratio between the 2.

Thank you,

Caroline

[radzmar · Accepted solution]

Hi,

this is only a formula from scratch, but it seems to work.

Put it into the calculate event of the 3rd field (must be a text field!!!).

Attention: This is ForcCalc not JavaScript, so make sure to select the correct language in the script editor.

[carojvi]

Hi,

Thank you, it does seem to work! Genius