BookmarkSubscribe
Choose Language Hide Translation Bar
saitcopuroglu
Community Trekker

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

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
vince_faller
Super User

Re: Range inside rows

ColMax(:TotalMain)-ColMin(:TotalMain)

Vince Faller - Predictum
4 REPLIES 4
vince_faller
Super User

Re: Range inside rows

ColMax(:TotalMain)-ColMin(:TotalMain)

Vince Faller - Predictum
saitcopuroglu
Community Trekker

Re: Range inside rows

Great Thank you.

0 Kudos
Highlighted
saitcopuroglu
Community Trekker

Re: Range inside rows

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

0 Kudos
vince_faller
Super User

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
0 Kudos