<div dir="ltr"><div>This worked perfectly - just need to add balances to it but I think this will do the trick</div><div>Keep you posted</div><div>thanks Bruce</div><div> </div><div>Scott</div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Mon, Aug 12, 2013 at 1:50 PM, Bruce Easton <span dir="ltr"><<a href="mailto:bruce@stn.com" target="_blank">bruce@stn.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5">On 8/12/13 1:20 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
> Actually, in my example there are 4 'physical' records (1234-0001 and<br>
> 1234-0002-1, 1234-0002-2, 1234-0002-3)<br>
> But for purposes of what I need to calculate it should only be 2<br>
> records.....so yes, regardless of how many -1 -2 -3 ,etc that are on the<br>
> end of the full acct number, it should only count the 'record' as 1 entity<br>
> So, let's suppose I have the following accounts for client number 1234:<br>
><br>
> 1234-0001 Bal Due 150.00<br>
> 1234-0002-1 Bal Due 200.00<br>
> 1234-0002-2 Bal Due 200.00<br>
> 1234-0002-3 Bal Due .00<br>
> 1234-0003 Bal Due 800.00<br>
> 1234-0004 Bal Due 500.00<br>
> 1234-0005-1 Bal Due 300.00<br>
> 1234-0005-2 Bal Due .00<br>
> 1234-0006 Bal Due 50.00<br>
> 1234-0007 Bal Due 150.00<br>
> 1234-0008-1 Bal Due .00<br>
> 1234-0008-2 Bal Due .00<br>
> 1234-0008-3 Bal Due 100.00<br>
> 1234-0008-4 Bal Due .00<br>
><br>
> The report I'm trying to create should show there are: 8 records (0001<br>
> thru 0008) even though several have -1, -2 etc<br>
> and it should only calcluate the balance once for each of the 8 records<br>
> with today bal due of 2250.00 (keeping in mind, it needs to look at all -1,<br>
> -2, etc in case only one of them has a bal due. So, in case of 1234-0008-1<br>
> thru -4, typically the original total bal due would probably have been<br>
> 400.00, and -1, -2 and -4 paid their 1/4 of orig bal due, so -3 still owes<br>
> 100.00<br>
> So what I want is a report of total 'active' entities (not physical<br>
> records) that have a balance and the total of the balances. So it should<br>
> count those records without any 'associate' people as 1 record (i.e.<br>
> 1234-0001, 1234-0003, 1234-0006 and 1234-0007 - obviously those are easy<br>
> because it's just one person to that account number -- the issue is not<br>
> counting 1234-0008-1 thru 1234-0008-4 as 4 records - just should be one<br>
> record...and only grab the balance due once<br>
> Hope that helps<br>
> thanks<br>
><br>
> Scott<br>
><br>
><br>
> On Mon, Aug 12, 2013 at 1:02 PM, Kenneth Brody <<a href="mailto:kenbrody@spamcop.net">kenbrody@spamcop.net</a>> wrote:<br>
><br>
>> On 8/12/2013 11:21 AM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
>><br>
>>> Should seem simple but let me explain...<br>
>>><br>
>> [...]<br>
>><br>
>> Some records will only have 1 person associated with it<br>
>>> i.e. 1234-0001 John Smith Balance 150.00<br>
>>> So, field 1 = 1234<br>
>>> Field 2 = 0001<br>
>>> Field 3 = 1234-0001<br>
>>><br>
>>> Some records will have multiple people associated with it<br>
>>> i.e. 1234-0002-1 John Smith Balance 200.00<br>
>>> 1234-0002-2 Mary Smith Balance 200.00<br>
>>> 1234-0002-3 Billy Smith Balance .00 (paid their portion)<br>
>>><br>
>>> In each case, each one of those should ONLY count as '1' record<br>
>>><br>
>>> What I'm trying to do is get a count for all records, soley based on first<br>
>>> 9 digits<br>
>>> So, if I run processing for client 1234, using the above example, it<br>
>>> should<br>
>>> show me I have 2 records (1234-0001 and 1234-0002, regardless that<br>
>>> 1234-0002 has -1 -2 and -3 associated with it.<br>
>>> Each of these will also have a balance associated with them. I'm only<br>
>>> wanting to pickup the balance 'once' for each of these records, even if<br>
>>> one<br>
>>> of the '-1, -2' etc has a zero balance.<br>
>>><br>
>> [...]<br>
>><br>
>> Why should those 3 records count as only 2? If you were shown those<br>
>> records and told to manually count them, by what process would you arrive<br>
>> at "2"?<br>
>><br>
>> Is it purely the fact that client number "1234" has records with "0001"<br>
>> and "0002", regardless of how many "0001" and "0002" records exist? Or is<br>
>> there some other calculation involved?<br>
>><br>
>> --<br>
>> Kenneth Brody<br>
>><br>
</div></div><div class="im">> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL: <a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20130812/fa5aad84/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20130812/fa5aad84/attachment.html</a><br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
> Subscribe/Unsubscribe/Subscription Changes<br>
> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
><br>
</div>Try output processing like this:<br>
<div class="im"><br>
1 ------- - - - - - -<br>
</div> ? If:<br>
Then: end<br>
<div class="im"> 2 ------- - - - - - -<br>
</div> ? If:<br>
Then: ad(7,.0,g)<br>
<div class="im"> 3 ------- - - - - - -<br>
</div>@wbrk1 ? If:<br>
Then: ad=ad+"1"; end<br>
<div class="im"> 4 ------- - - - - - -<br>
</div>@wbrk2 ? If:<br>
Then: print; ad=""; end<br>
<br>
to go with an output format defined as looking similar to this:<br>
<br>
- - - SUBTOTAL BY REC - - -<br>
<br>
- - - SUBTOTAL BY CLIENT -<br>
*1 *ad<br>
<br>
and sort for the output format like this:<br>
<br>
<br>
Sort Field: 1 2<br>
Length: 4 4<br>
Descending:<br>
Subtotal Field: x? x?<br>
<br>
===========<br>
(no sort/selection prc needed)<br>
<span class="HOEnZb"><font color="#888888"><br>
Bruce<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br></div>