Subscribe Bookmark RSS Feed

Range inside rows

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

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
Solution

ColMax(:TotalMain)-ColMin(:TotalMain)

4 REPLIES
Solution

ColMax(:TotalMain)-ColMin(:TotalMain)

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

Great Thank you.

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

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

vince_faller

Super User

Joined:

Mar 17, 2015

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.