Marc, Do you have to show the balance on every line? balance = (sum(charge) - sum(payment)) ???? ----- Original Message ----- From: "Marc" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 01, 2004 3:15 PM Subject: [RBG7-L] - Re: Form calculation
> HI Bernie > > Now my table structure is > Custnum Date Amount > Charges are + and Payments are - > A the end of the day I do a Sum(amount) and update the > balance in the Patient file. > > I have seen other programs that seem to work this way > Custnum Date Charge Payment Balance > 101 1/1/04 $50 $0 $50 > 101 1/1/05 $50 -$20 $80 > > So, the second line must take the balance from the first > line, add the charge from the second line, subtract the > payment on the second line to get the $80 balance. > > I know how to do this in a spreadsheet but I do not have > any idea how to do it in RBase or if it is even possible. > It really is not a big deal, I was just wondering it this > way has any advantages to my way. > > > Marc > > > > > > > > ----- Original Message ----- > From: "Bernard Lis" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, September 01, 2004 1:54 PM > Subject: [RBG7-L] - Re: Form calculation > > > > Sounds like you have a one to many relationship here. > > One original charge and many payments. > > In this case I would make a separate payment table consisting of an > Invoice > > No. and payment amount and perhaps payment type (check, credit card, > cash), > > etc. > > then on your form you could show the original charge and in a region show > > the payments, and the final balance due. > > How about adding an ageing - 30 60 90, etc. > > Hope this helps, if not perhaps you could explain more about your > > application. > > Bernie Lis > > ----- Original Message ----- > > From: "Marc" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Wednesday, September 01, 2004 2:31 PM > > Subject: [RBG7-L] - Re: Form calculation > > > > > > > Hi Bernie > > > > > > That part makes sense but how do you get the > > > formula to use the Balance from the line above, > > > then add the next lines charges - the payments. > > > > > > Marc > > > > > > > > > > Marc, > > > > If a value is changed, place a bit button on your form with caption > > "Save > > > > Changes", create an eep that does a saverow. Put a hint in, that says > > "If > > > > you made any changes, click here to update" > > > > Then refresh the form. > > > > Bernie Lis > > > > ----- Original Message ----- > > > > From: "Marc" <[EMAIL PROTECTED]> > > > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > > > Sent: Wednesday, September 01, 2004 8:47 AM > > > > Subject: [RBG7-L] - Form calculation > > > > > > > > > > > > > HI all > > > > > > > > > > Is it possible to have a forumla something like a spreadsheet > > > > > in a region. > > > > > > > > > > I want something like this > > > > > Charge payment Balance > > > > > $50 $0 $50 > > > > > $50 -$20 $80 > > > > > > > > > > and if you changed one of the payments or charges the balance > > > > > on that line would be re-calculated and all of the rows below > > > > > as well. > > > > > > > > > > I can figure out how to do one line but I can't figure out how to > > > > > include the Balance form the line above. > > > > > > > > > > Thanks > > > > > Marc > > > > > > > > > > --- RBG7-L > > > > > ================================================ > > > > > TO POST A MESSAGE TO ALL MEMBERS: > > > > > Send a plain text email to [EMAIL PROTECTED] > > > > > > > > > > (Don't use any of these words as your Subject: > > > > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > > > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > > > > ================================================ > > > > > TO SEE MESSAGE POSTING GUIDELINES: > > > > > Send a plain text email to [EMAIL PROTECTED] > > > > > In the message SUBJECT, put just one word: INTRO > > > > > ================================================ > > > > > TO UNSUBSCRIBE: > > > > > Send a plain text email to [EMAIL PROTECTED] > > > > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > > > > ================================================ > > > > > TO SEARCH ARCHIVES: > > > > > Send a plain text email to [EMAIL PROTECTED] > > > > > In the message SUBJECT, put just one word: SEARCH-n > > > > > (where n is the number of days). In the message body, > > > > > place any > > > > > text to search for. > > > > > ================================================ > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
