Range inside rows

[#1]

How to calculate range inside rows which I can solve by Graph Builder at the report platform but where/what is the formula for it?

I would like to calculate the difference between 7,666,601.00 and 5,039,955.00...

The number comes by a ColSum byVariable formula

[#2 · Accepted solution]

ColMax(:TotalMain)-ColMin(:TotalMain)

[#3]

Great Thank you.

[#4]

Is there a 'RANGE' or 'DIFFERENCE' formula inside JMP by the way?

[#5]

The minus ( - ) sign? Maybe I'm missing something.

Also, you should totally check out Help>>scripting index. 

It's probably my favorite thing about JMP.