topic Range inside rows in Discussions https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12145#M11586 <HTML><HEAD></HEAD><BODY><P>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?</P><P>I would like to calculate the difference between 7,666,601.00 and 5,039,955.00...</P><P>The number comes by a ColSum byVariable formula</P><P></P><P></P><P></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8686_Screen Shot 2015-04-29 at 17.07.51.png" style="width: 119px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/1510i1107599D3AD5C772/image-size/medium?v=v2&amp;px=400" role="button" title="8686_Screen Shot 2015-04-29 at 17.07.51.png" alt="8686_Screen Shot 2015-04-29 at 17.07.51.png" /></span></P></BODY></HTML> Tue, 18 Oct 2016 23:12:03 GMT saitcopuroglu 2016-10-18T23:12:03Z Range inside rows https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12145#M11586 <HTML><HEAD></HEAD><BODY><P>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?</P><P>I would like to calculate the difference between 7,666,601.00 and 5,039,955.00...</P><P>The number comes by a ColSum byVariable formula</P><P></P><P></P><P></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8686_Screen Shot 2015-04-29 at 17.07.51.png" style="width: 119px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/1510i1107599D3AD5C772/image-size/medium?v=v2&amp;px=400" role="button" title="8686_Screen Shot 2015-04-29 at 17.07.51.png" alt="8686_Screen Shot 2015-04-29 at 17.07.51.png" /></span></P></BODY></HTML> Tue, 18 Oct 2016 23:12:03 GMT https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12145#M11586 saitcopuroglu 2016-10-18T23:12:03Z Re: Range inside rows https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12146#M11587 <HTML><HEAD></HEAD><BODY><P>ColMax(:TotalMain)-ColMin(:TotalMain)</P></BODY></HTML> Wed, 29 Apr 2015 14:29:13 GMT https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12146#M11587 vince_faller 2015-04-29T14:29:13Z Re: Range inside rows https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12147#M11588 <HTML><HEAD></HEAD><BODY><P>Great Thank you.</P></BODY></HTML> Wed, 29 Apr 2015 14:31:15 GMT https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12147#M11588 saitcopuroglu 2015-04-29T14:31:15Z Re: Range inside rows https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12148#M11589 <HTML><HEAD></HEAD><BODY><P>Is there a 'RANGE' or 'DIFFERENCE' formula inside JMP by the way?</P></BODY></HTML> Wed, 29 Apr 2015 14:32:37 GMT https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12148#M11589 saitcopuroglu 2015-04-29T14:32:37Z Re: Range inside rows https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12149#M11590 <HTML><HEAD></HEAD><BODY><P>The minus ( - ) sign? Maybe I'm missing something. </P><P></P><P>Also, you should totally check out Help&gt;&gt;scripting index.&nbsp; </P><P></P><P>It's probably my favorite thing about JMP.&nbsp; </P></BODY></HTML> Wed, 29 Apr 2015 14:34:43 GMT https://community.jmp.com/t5/Discussions/Range-inside-rows/m-p/12149#M11590 vince_faller 2015-04-29T14:34:43Z