How do I calculate a ratio with negative numbers

[#1]

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?

[#2 · Accepted solution]

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

The functions are available at:

     Help==>Scripting Index==>Functions,

or in the Formula Editor 

[#3]

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