cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
saitcopuroglu
saitcopuroglu
Level IV

Range inside rows

Created: Apr 29, 2015 10:13 AM  |  Last Modified: Oct 18, 2016 4:12 PM (9373 views)

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 (Alumni) vince_faller
Super User (Alumni)
Solution

Re: Range inside rows

Apr 29, 2015 10:29 AM (11436 views)  |  Posted in reply to message from saitcopuroglu 04-29-2015

ColMax(:TotalMain)-ColMin(:TotalMain)

Vince Faller - Predictum

View solution in original post

4 REPLIES 4
vince_faller
Super User (Alumni) vince_faller
Super User (Alumni)
Solution

Re: Range inside rows

Apr 29, 2015 10:29 AM (11437 views)  |  Posted in reply to message from saitcopuroglu 04-29-2015

ColMax(:TotalMain)-ColMin(:TotalMain)

Vince Faller - Predictum
saitcopuroglu
saitcopuroglu
Level IV

Re: Range inside rows

Apr 29, 2015 10:31 AM (9285 views)  |  Posted in reply to message from vince_faller 04-29-2015

Great Thank you.

0 Kudos
saitcopuroglu
saitcopuroglu
Level IV

Re: Range inside rows

Apr 29, 2015 10:32 AM (9285 views)  |  Posted in reply to message from vince_faller 04-29-2015

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

0 Kudos
vince_faller
Super User (Alumni) vince_faller
Super User (Alumni)

Re: Range inside rows

Apr 29, 2015 10:34 AM (9285 views)  |  Posted in reply to message from saitcopuroglu 04-29-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. 

Vince Faller - Predictum
0 Kudos