Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events
SOLVED

## Auto-Fill in of minimum value

Level 3

I have two cells being calculated. I want the the third cell to automatically fill-in based upon the lesser of those two values.

Example: If cell1 = 5 and cell2 = 7, cell3 should autofill with 5, the lessor of the two

If cell1 = 5 and cell2 =3, cell3 sould fill with 3.

Formula so far in layout:

if (MaxLoan > MaxLoanLTV) then // NewLoan

MaxLoan.presence = "visible"

MaxLoanLTV.presence = "hidden"

elseif (MaxLoanLTV > MaxLoan) then

MaxLoan.presence = "hidden"

MaxLoanLTV.presence = "visible"

endif

Formula in calculate:

\$ = sum(MaxLoan) // NewLoan

\$ = sum(MaxLoanLTV) // NewLoan

It does reflect a number but not the minimum value.

Thank you.

1 Accepted Solution

Level 5

Hi,

you have t copy this script in the calculate event of your target field, use Javascript.

`this.rawValue =  Math.min(num_1.rawValue, num_2.rawValue);`

Hope it will helps you,

Mandy

2 Replies

Level 5

Hi,

you have t copy this script in the calculate event of your target field, use Javascript.

`this.rawValue =  Math.min(num_1.rawValue, num_2.rawValue);`

Hope it will helps you,

Mandy

Level 3

Thank you, worked great!