<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Jose,<div><span class="Apple-tab-span" style="white-space:pre"> </span>Thanks! I'll give it a try. I haven't done much with writing programs in pro Fit, maybe I should expand my repertoire!</div><div><br></div><div>Dave<br><div><div>On Oct 13, 2011, at 12:10 AM, Jose Ignacio Espeso wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">What about using a simple program? It could be as easy as this one:<div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "><span style="color: #280cd4">program</span> RunningSum;</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "> <span class="Apple-style-span" style="color: rgb(40, 12, 212); ">var</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "> i,col1,col2:<span style="color: #280cd4">integer</span>;</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; color: rgb(40, 12, 212); "><span style="color: #000000"> sum:</span>extended<span style="color: #000000">;</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; color: rgb(40, 12, 212); ">begin</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "> <span style="color: rgb(31, 168, 69); ">Input</span><span style="color: rgb(0, 0, 0); ">(</span><font class="Apple-style-span" color="#797979">'Input Column'</font><span style="color: rgb(0, 0, 0); ">,col1,</span><font class="Apple-style-span" color="#797979">'Output Column'</font><span style="color: rgb(0, 0, 0); ">,col2);</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "> sum:=0;</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "> <span style="color: #280cd4">for</span> i:=1 <span style="color: #280cd4">to</span> <span style="color: #1fa845">nrRows</span> <span style="color: #280cd4">do</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "> <span style="color: #280cd4">if</span> <span style="color: #1fa845">DataOK</span>(i,col1) <span style="color: #280cd4">then</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "> <span class="Apple-style-span" style="color: rgb(40, 12, 212); ">begin</span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "> sum:=sum+<span style="color: #1fa845">data</span>[i,col1];</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "> <span style="color: #1fa845">data</span>[i,col2]:=sum;</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; "> <span style="color: #280cd4">end</span>;</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 9px/normal Monaco; color: rgb(40, 12, 212); ">end<span style="color: #000000">;</span></div><div><span style="color: #000000"><br></span></div><div><span style="color: #000000"><br></span></div><div>
<span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; -webkit-text-decorations-in-effect: none; text-indent: 0px; -webkit-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> /~~~~~~~~~~~~~~~~~~~~~~~~~~\</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> | <span class="Apple-converted-space"> </span>Jose I. ESPESO | A/~~~\A</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> | Dpto. CITIMAC | ((o o))___ </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> | Universidad de Cantabria | \ / ~~~</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> # | <span class="Apple-converted-space"> </span>39005 Santander | # (---)\ # </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">-#--x---| SPAIN |----#-x---x---x---#---</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> # \_________________________/ # \ # </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">-#--x------| |--#---x---x---x-| |--x-------x---x---x---#-x---x---x---#---</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> #(// \\) | | )#(// \\)(// \\) | | (// \\)(// \\)(/ \)(/ \) # (// \\)(// \\) #</div></span></div></span></div></span></span>
</div>
<br><div><div>El 11/10/2011, a las 22:42, Dave Sopchak escribió:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hi all,<br><br>Is there a way to do a "running sum" of a column in pro fit? I mean, display the total of all values in a column thus far in the column next to it? <br><br>Nothing jumped out at me immediately. I know this is kind of a spreadsheet thing to do, but it would help if I could do this all in pro fit.<br><br>Thanks for any and all…<br><br>Dave<br><br><br>_______________________________________________<br><br>proFit-list mailing list<br><a href="mailto:proFit-list@quantum-soft.com">proFit-list@quantum-soft.com</a><br><a href="http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com">http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com</a><br></div></blockquote></div><br></div></div>_______________________________________________<br>proFit-list mailing list<br><a href="mailto:proFit-list@quantum-soft.com">proFit-list@quantum-soft.com</a><br>http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com<br></blockquote></div><br></div></body></html>