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: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. ET on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

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 (10247 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 (12310 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 (12311 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 (10159 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 (10159 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 (10159 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