<div dir="ltr">Thank you so much Chris Randal, Brian White, Richard Kreiss,  the TOT processing is the winner,  luv filePro.  <div><br></div><div><div>-- <br></div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Wayne Smith<div>Port Orange, Florida</div><div><br></div><div><table class="gmail-Bs gmail-nH gmail-iY gmail-bAt" cellpadding="0" style="border-spacing:0px;padding:0px;border-collapse:collapse;width:854px;display:block;color:rgb(32,33,36);font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:medium"><tbody><tr><td class="gmail-Bu gmail-yM" style="vertical-align:top;padding:0px;width:0px;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial"></td><td class="gmail-Bu gmail-bAn" style="vertical-align:top;padding:0px;display:block;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial"><div class="gmail-nH gmail-if" style="margin:0px 16px 0px 0px;padding:0px"><div class="gmail-nH gmail-aHU" style=""><div class="gmail-nH gmail-hx" style="background-color:transparent;color:rgb(34,34,34);min-width:502px;padding:0px"><div class="gmail-nH"><div class="gmail-h7 gmail-ie gmail-nH gmail-oy8Mbf" tabindex="-1" style="clear:both;padding-bottom:0px;max-width:100000px;outline:none"><div class="gmail-Bk" style="margin-bottom:0px;border-width:0px;border-top-style:solid;border-right-style:initial;border-bottom-style:initial;border-left-style:initial;border-top-color:rgb(239,239,239);border-right-color:initial;border-left-color:initial;border-bottom-color:initial;border-radius:0px;width:838px;float:none"><div class="gmail-G3 gmail-G2" style="padding-top:0px;background-color:transparent;border-right:0px;border-bottom:0px rgba(100,121,143,0.12);border-left:0px;border-top:none;border-radius:0px;margin-bottom:0px;margin-left:0px;margin-right:0px"><div><div id="gmail-:1o8"><div class="gmail-adn gmail-ads" style="border-left:none;padding:0px;display:flex"><div class="gmail-gs" style="margin:0px;padding:0px 0px 20px;width:774px"><div class="gmail-gE gmail-iv gmail-gt" style="padding:20px 0px 0px;font-size:12px"><br class="gmail-Apple-interchange-newline"><table cellpadding="0" class="gmail-cf gmail-gJ" style="border-collapse:collapse;margin-top:0px;width:auto;font-size:0.875rem;letter-spacing:0.2px;display:block"><tbody style="display:block"><tr class="gmail-acZ" style="height:auto;display:flex"><td class="gmail-gF gmail-gK" style="white-space:nowrap;padding:0px;vertical-align:top;width:542.719px;line-height:20px;display:block;max-height:20px"><table cellpadding="0" class="gmail-cf gmail-ix" style="border-collapse:collapse;table-layout:fixed;width:542px"><tbody><tr><td class="gmail-c2" style="display:flex"><h3 class="gmail-iw" style="overflow:hidden;font-size:0.75rem;font-weight:inherit;margin:inherit;text-overflow:ellipsis;letter-spacing:0.3px;color:rgb(95,99,104);line-height:20px"><span class="gmail-qu" tabindex="-1"><span name="Chris Rendall via Filepro-list" class="gmail-gD" style="color:rgb(32,33,36);font-size:0.875rem;font-weight:bold;display:inline;vertical-align:top;letter-spacing:0.2px;line-height:20px">Chris Rendall via Filepro-list</span></span></h3></td></tr></tbody></table></td><td class="gmail-gH gmail-bAk" style="text-align:right;white-space:nowrap;vertical-align:top;display:block;max-height:20px"><div class="gmail-gK" style="padding:0px;display:flex"><span id="gmail-:1nj" class="gmail-g3" title="Apr 27, 2019, 2:39 PM" alt="Apr 27, 2019, 2:39 PM" tabindex="-1" style="vertical-align:top;margin:0px;font-size:0.75rem;letter-spacing:0.3px;color:rgb(95,99,104);display:block;line-height:20px">2:39 PM (1 hour ago)</span><div class="gmail-zd gmail-bi4" title="Not starred" tabindex="0" style="display:inline-block;height:20px;margin-left:20px;outline:0px"><span class="gmail-T-KT" style="display:inline-flex;height:20px;text-align:center;width:20px;padding:0px;margin:0px;border:none;outline:none"></span></div></div></td><td class="gmail-gH" style="text-align:right;white-space:nowrap;vertical-align:top;display:flex"></td><td class="gmail-gH gmail-acX gmail-bAm" rowspan="2" style="text-align:right;white-space:nowrap;vertical-align:top;display:block;max-height:20px"><div class="gmail-T-I gmail-J-J5-Ji gmail-T-I-Js-IF gmail-aaq gmail-T-I-ax7 gmail-L3" tabindex="0" style="display:inline-flex;border-radius:2px 0px 0px 2px;font-size:0.875rem;text-align:center;margin:0px 0px 0px 20px;height:20px;line-height:18px;min-width:0px;outline:none;padding:0px;background:transparent;color:rgb(68,68,68);border:none"><img class="gmail-hB gmail-T-I-J3" src="https://mail.google.com/mail/u/0/images/cleardot.gif" alt="" style="background: url("https://www.gstatic.com/images/icons/material/system/1x/reply_black_20dp.png") 50% 50% / 20px no-repeat; height: 20px; margin: 0px; vertical-align: middle; width: 20px; opacity: 0.54; display: inline-block; padding: 0px; transition: opacity 0.15s cubic-bezier(0.4, 0, 0.2, 1) 0s;"></div><div id="gmail-:18k" class="gmail-T-I gmail-J-J5-Ji gmail-T-I-Js-Gs gmail-aap gmail-T-I-awG gmail-T-I-ax7 gmail-L3" tabindex="0" style="display:inline-flex;border-radius:0px 2px 2px 0px;font-size:0.875rem;text-align:center;margin:0px 0px 0px 20px;height:20px;line-height:18px;min-width:0px;outline:none;padding:0px;background:transparent;color:rgb(68,68,68);border:none"><img class="gmail-hA gmail-T-I-J3" src="https://mail.google.com/mail/u/0/images/cleardot.gif" alt="" style="background: url("https://www.gstatic.com/images/icons/material/system/1x/more_vert_black_20dp.png") 50% 50% / 20px no-repeat; height: 20px; width: 20px; margin: 0px; vertical-align: middle; opacity: 0.54; display: inline-block; padding: 0px; transition: opacity 0.15s cubic-bezier(0.4, 0, 0.2, 1) 0s;"></div></td></tr><tr class="gmail-acZ gmail-xD" style="height:auto;display:flex"><td colspan="3"><table cellpadding="0" class="gmail-cf gmail-adz" style="border-collapse:collapse;table-layout:fixed;white-space:nowrap;width:774px"><tbody><tr><td class="gmail-ady" style="overflow:visible;text-overflow:ellipsis;display:flex;line-height:20px"><div class="gmail-iw gmail-ajw" style="overflow:hidden;max-width:92%;display:inline-block"><span class="gmail-bfM" style="background:url("https://ssl.gstatic.com/mail/sprites/smime-69772d50adad95aedb3d9639945f861d.png") 0px 0px no-repeat;display:inline-block;height:18px;vertical-align:top;width:18px"></span> <span class="gmail-hb" style="vertical-align:top;color:rgb(95,99,104);font-size:0.75rem;letter-spacing:0.3px;line-height:20px">to <span dir="ltr" name="filePro" class="gmail-g2" style="vertical-align:top">filePro</span></span></div><div class="gmail-ajy" tabindex="0" style="display:inline-flex;margin-left:4px;vertical-align:top;border:none;outline:none"><img class="gmail-ajz" id="gmail-:1p9" src="https://mail.google.com/mail/u/0/images/cleardot.gif" alt="" style="background: url("https://www.gstatic.com/images/icons/material/system/1x/arrow_drop_down_black_20dp.png") 50% 50% / 20px no-repeat; cursor: pointer; padding: 0px; vertical-align: baseline; height: 20px; width: 20px; border: none; margin: 0px 0px 0px auto; right: 0px; top: 0px; display: flex; opacity: 0.54;"></div></td></tr></tbody></table></td></tr></tbody></table></div><div id="gmail-:1o7"><div class="gmail-qQVYZb"></div><div class="gmail-utdU2e"></div><div class="gmail-btm"></div></div><div class="gmail-"><div class="gmail-aHl" style=""></div><div id="gmail-:1ob" tabindex="-1"></div><div id="gmail-:1oe" class="gmail-ii gmail-gt" style="font-size:12px;direction:ltr;margin:8px 0px 0px;padding:0px"><div id="gmail-:1o6" class="gmail-a3s gmail-aXjCH" style="overflow:hidden;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:small;line-height:1.5;font-family:Arial,Helvetica,sans-serif">Try changing line 1 to: ec(10,.2)=tot(8*5), and line 2 to es(10,.2)=tot(8*6).<br><br><br><br>--- Chris<br><br><br><br>From: Wayne Smith via Filepro-list<mailto:<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>><br>Sent: Saturday, April 27, 2019 8:36 AM<br>To: filePro Mailing List<mailto:<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>><br>Subject: Grand Total Processing<br><br><br><br>Could one of you wizards tell me what I am doing wrong with the processing<br>below....trying to post a Total Inventory amount and count in a history<br>file for the day.  Its posting the file with one record as it should but<br>the totals are wrong ...help.<br><br>[image: GrandTotalProc.JPG]<br><br>--<br>Wayne Smith<br>Port Orange, Florida<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190427/398ca7d7/attachment.html" rel="noreferrer" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20190427/398ca7d7/attachment.html</a>><br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: GrandTotalProc.JPG<br>Type: image/jpeg<br>Size: 86185 bytes<br>Desc: not available<br>URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190427/398ca7d7/attachment.jpe" rel="noreferrer" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20190427/398ca7d7/attachment.jpe</a>><br>_______________________________________________<br>Filepro-list mailing list<br><a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>Subscribe/Unsubscribe/Subscription Changes<br><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>_______________________________________________<br>Filepro-list mailing list<br><a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>Subscribe/Unsubscribe/Subscription Changes<br><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><div class="gmail-yj6qo"></div><div class="gmail-adL"><br></div></div></div><div class="gmail-hi" style="border-bottom-left-radius:1px;border-bottom-right-radius:1px;padding:0px;width:auto;background:rgb(242,242,242);margin:0px"></div></div></div><div class="gmail-ajx" style="clear:both"></div></div><div class="gmail-gA gmail-gt gmail-acV" style="font-size:12px;padding:0px;width:auto;border-bottom-left-radius:0px;border-bottom-right-radius:0px;border-top:none;margin:0px;background:transparent"><div class="gmail-gB gmail-xu" style="border-top:0px;padding:0px"><div class="gmail-ip gmail-iq" style="clear:both;margin:0px;padding:16px 0px;border-top:none"><div id="gmail-:1nk"><table class="gmail-cf gmail-wS" style="border-collapse:collapse"><tbody><tr><td class="gmail-amq" style="padding:0px 16px;vertical-align:top;width:44px"><img id="gmail-:m2_47" name=":m2" src="https://www.google.com/s2/u/0/photos/public/AIbEiAIAAABECPXV-YjAyKuJlAEiC3ZjYXJkX3Bob3RvKig4YzQ0YWI1ZWVlYzFlMjI2MjQ1ZDQ3NjNjN2RjNWM4ODQ3YmE5OTI4MAEE3xG5ahKTbxtvbFsOD_kfvNCYTw?sz=32" class="gmail-ajn gmail-bofPge" style="display: block; width: 32px; height: 32px; border-radius: 50%;"></td><td class="gmail-amr" style="padding:0px;width:774px"><div class="gmail-nr gmail-wR" style="padding:0px;box-sizing:border-box;border-radius:1px;border:none;margin:0px"><div class="gmail-amn" style="color:inherit;height:auto;padding:0px;display:flex;line-height:20px"><span id="gmail-:1p8" tabindex="0" class="gmail-ams gmail-bkH" style="border:none;display:inline-flex;font-family:"Google Sans",Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:0.875rem;letter-spacing:0.25px;background:none;border-radius:4px;box-sizing:border-box;color:rgb(95,99,104);height:36px;outline:none;padding:0px 16px 0px 12px;min-width:104px;margin-right:12px">Reply</span><span id="gmail-:1np" tabindex="0" class="gmail-ams gmail-bkI" style="border:none;display:inline-flex;font-family:"Google Sans",Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:0.875rem;letter-spacing:0.25px;background:none;border-radius:4px;box-sizing:border-box;color:rgb(95,99,104);height:36px;outline:none;padding:0px 16px 0px 12px;min-width:104px;margin-right:12px">Reply all</span><span id="gmail-:1o9" tabindex="0" class="gmail-ams gmail-bkG" style="border:none;display:inline-flex;font-family:"Google Sans",Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:0.875rem;letter-spacing:0.25px;background:none;border-radius:4px;box-sizing:border-box;color:rgb(95,99,104);height:36px;outline:none;padding:0px 16px 0px 12px;min-width:104px;margin-right:12px">Forward</span></div></div></td></tr></tbody></table></div></div></div></div></div></div></div></div></div></div><div class="gmail-nH"></div><div class="gmail-nH"></div></div></div><div class="gmail-nH"><div class="gmail-l2 gmail-pfiaof" style="margin:0px 0px 16px;padding:0px 16px 0px 64px;text-align:center"><div id="gmail-:1ow"></div><div id="gmail-:1pd" class="gmail-aeV" style="float:left;width:252.406px;text-align:left"><div><div class="gmail-md gmail-mj" style="font-size:0.75rem;color:rgb(95,99,104);padding-top:0px;letter-spacing:0.3px;line-height:20px"><div><span dir="ltr"></span><span dir="ltr"></span></div><div class="gmail-aeW"><a target="_blank" href="https://drive.google.com/u/0/settings/storage?hl=en" class="gmail-l8" style="color:rgb(34,34,34);text-decoration-line:none"></a></div></div></div></div><div class="gmail-aeU" style="float:left;width:252.406px"><div id="gmail-:171"><div><div class="gmail-ma" style="font-size:0.75rem;color:rgb(95,99,104);padding-top:0px;letter-spacing:0.3px;line-height:20px"><a href="https://www.google.com/intl/en/policies/terms/" target="_blank" class="gmail-l9" style="color:rgb(34,34,34);text-decoration-line:none"></a><a href="https://www.google.com/intl/en/policies/privacy/" target="_blank" class="gmail-l9" style="color:rgb(34,34,34);text-decoration-line:none"></a><a href="https://www.google.com/gmail/about/policy/" target="_blank" class="gmail-l9" style="color:rgb(34,34,34);text-decoration-line:none"></a></div></div></div></div><div id="gmail-:16z" class="gmail-ae3" style="float:left;width:252.406px;text-align:right"><div><div class="gmail-l6" style="padding-top:0px;font-size:0.75rem;color:rgb(95,99,104);letter-spacing:0.3px;line-height:20px"><div></div><span id="gmail-:1og" class="gmail-l8 gmail-LJOhwe" tabindex="0" style="color:rgb(34,34,34)"></span></div></div></div><div style="clear:both"></div></div></div></div></td><td class="gmail-Bu gmail-yM" style="vertical-align:top;padding:0px;width:0px;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial"><div class="gmail-Bt" style="height:0px;overflow:hidden;width:0px"></div><div class="gmail-nH" style="width:0px"><div class="gmail-no" style="float:left"><div class="gmail-nH gmail-nn" style="min-height:1px;float:left;width:0px"></div></div></div></td></tr></tbody></table><br class="gmail-Apple-interchange-newline"></div></div></div></div></div>