Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

Ratio format 5:1

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

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.

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

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.

Avatar

Level 2

Hi,

Thank you, it does seem to work! Genius