topic Re: How do I calculate a ratio with negative numbers in Discussions

How do I calculate a ratio with negative numbers

rj69 — Wed, 16 Aug 2017 19:30:31 GMT

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?

Re: How do I calculate a ratio with negative numbers

txnelson — Wed, 16 Aug 2017 19:45:30 GMT

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

The functions are available at:

Help==>Scripting Index==>Functions,

or in the Formula Editor

Re: How do I calculate a ratio with negative numbers

rj69 — Wed, 16 Aug 2017 19:51:09 GMT

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