Community Trekker

Joined:

May 9, 2016

## How do I calculate a ratio with negative numbers

Without using scripting, I want to create a formula that computes a ratio between two columns of CAGR percentages, taking into account that some of the percentages are negative (meaning simple division will not suffice). A formula that might accomplish this is:

If the above formula would work, how would I incorporate the comma in the JMP formula box? Or, is there a better way to compute the ratio?

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Joined:

Jun 22, 2012

Solution

## Re: How do I calculate a ratio with negative numbers

``abs(x-y)/max(abs(x),abs(y))``

The functions are available at:

Help==>Scripting Index==>Functions,

or in the Formula Editor

Jim
2 REPLIES

Super User

Joined:

Jun 22, 2012

Solution

## Re: How do I calculate a ratio with negative numbers

``abs(x-y)/max(abs(x),abs(y))``

The functions are available at:

Help==>Scripting Index==>Functions,

or in the Formula Editor

Jim

Community Trekker

Joined:

May 9, 2016

## Re: How do I calculate a ratio with negative numbers

Got it. Wasn't sure of the notation for the comma. Thank you.