User Community
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: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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 (11125 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 (13188 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 (13189 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 (11037 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 (11037 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 (11037 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

Recommended Articles