Subscribe Bookmark RSS Feed

How do I calculate a ratio with negative numbers

rj69

Community Trekker

Joined:

May 9, 2016

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:formula.JPG

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
txnelson

Super User

Joined:

Jun 22, 2012

Solution
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
txnelson

Super User

Joined:

Jun 22, 2012

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

The functions are available at:

     Help==>Scripting Index==>Functions,

or in the Formula Editor 

Jim
rj69

Community Trekker

Joined:

May 9, 2016

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