SimonB

Hi Chuck, Sorry I didn't get back to you sooner. I came back later that night and had a brainwave. I just discovered how to use extend. Which I knew existed but got the wrong end of the stick on it. I suddenly realized what the problem was...I had referenced non-repeating fields! Ta very much for your follow-up though and I am sure that I will find something else to mess up. This will teach me to not look at a product for 10 years and then expect to go back just like that.

Column 1. Payment entry (6 reps) Column 2. Calculates Avail$ for commissions (payment-company cut)Displayed (6 reps) Column 3. Takes result of column 2 and splits it by split to salesperson(s) such as 50/50/0 or 50/25/25 whatever is determined by management (max split is between 3 possible people). Displayed (6 reps) Column 4. Calculates final $ to individual salesperson (result of column3*individual commission rate of salesperson (6 reps). Therefore I have 3 more columns the same as this one (6 reps). The intention was to show a balance sheet showing the state of payments for that order and the salespersons.

I have been asked to leave the original alone. I thought this should work also... payments field (upto 6 possible entries) is first calculated for a dollars available field (upto 6 possible amounts)which is then used to calculate commissions, which are split up for 3 salespersons with unique commissions. It looks like a spread sheet and in fact is intended too. It is essentially a balance sheet for commissions. However when I enter new payments in the repeat fields which should in turn give me results in the repeat calculation fields. I get 00.00 across the board...I have noticed that if I remove all calculations and replace with something like 1*1*2 that I do get results...so what am I doing wrong?

I am new to Filemaker. I have the job of changing an existing file that has a repeating field in it (6 repeating unique payments). Which I have to show calculations for commissions with things like (Should Be Sold Price : / Total Lot Price * $ Value Shipped) for several sales people in a repeating fashion. I currently only seem to get 00.00 on entering new payments! I tried get repeatition but this only seems to work for one. How do you set up repeating calculations....perplexed!