cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
rj69
Level III

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: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

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

View solution in original post

2 REPLIES 2
txnelson
Super User

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
rj69
Level III

Re: How do I calculate a ratio with negative numbers

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