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
saitcopuroglu
Level IV

Range inside rows

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

8686_Screen Shot 2015-04-29 at 17.07.51.png

1 ACCEPTED SOLUTION

Accepted Solutions
vince_faller
Super User (Alumni)

Re: Range inside rows

ColMax(:TotalMain)-ColMin(:TotalMain)

Vince Faller - Predictum

View solution in original post

4 REPLIES 4
vince_faller
Super User (Alumni)

Re: Range inside rows

ColMax(:TotalMain)-ColMin(:TotalMain)

Vince Faller - Predictum
saitcopuroglu
Level IV

Re: Range inside rows

Great Thank you.

saitcopuroglu
Level IV

Re: Range inside rows

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

vince_faller
Super User (Alumni)

Re: Range inside rows

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. 

Vince Faller - Predictum