Recent content by marylally

Group Header 1 Emp_id 2007 Pamela L. Group Header 2 Week 28 Tours(period counter) Sales VPG 13 10,400 800 Week 29 19 33,740 1776 Detail section (hidden)contains in period ctr and prior ctr Group Footer 2...

Didn't work, @in period //IIF ({OPP0100_HIST_LAST.BKDATE}>={PAY_PERIOD.BEGIN_DT},True , False) //IIF ({PAYABLES_LEDGER.PAY_DATE}>={PAY_PERIOD.BEGIN_DT},True , False) IIF ({PAYABLES_LEDGER.PAY_DATE}={PAY_PERIOD.PAY_DATE},True , False) @in period counter IIF ({@in period},1 ,0 ) @prior period...

It works but not on every one.? MaryBeth

Now I have an error where there is only one record for vpg my @sumavg is zero. Week 1 vpg = 0 Week 2 vpg = 2283 Sumavg should = 2283/2 = 1142 MaryBeth

THanks! That worked! Much appreciated Mary MaryBeth

I have a report that is grouped by Emp and Weeks I have created a formula that calculated an average. @vpg sum ({@SalesVol}, {PAYABLES_LEDGER.PAY_WK})/Count ({@in period counter}, {PAYABLES_LEDGER.PAY_WK}) This works fine and calculates correctly for all emp The problem is in my @sumavg...

I added another section, should I delete it? MaryBeth

Sorry, Group Footer 3 MaryBeth

Yes, you are correct. I can enter 2 weeks at a time to get an average of the 2 weeks for each employee Mary MaryBeth

I don't have a group 3 Sorry I forgot the links, the reports are linked by emp_id and Week number Mary MaryBeth

Hi LB, Group 1 Emp_Id in Main report and sub report Group 2 @Week in Main and Sub tourb in main report located in GF3 Main: WhilePrintingRecords;Shared numberVar tourb := Count ({@in period counter}, {PAYABLES_LEDGER.PAY_WK}) totala in sub located in GF3 Main: WhilePrintingRecords;Shared...

New Problem: I thought I solved the problem but now I my new formula field is adding the @test value for each employee. Emp 1 vpgpass $ 1288. Emp 2 @vpgpass $3446. should be $2158. but this is adding 1288. to 2158. to get a value of 3446. @test= whileprintingrecords; shared currencyvar test...

I lB, I was able to add an additional sub report and pull the next second record to get my value. It takes the report longer to run but worked. Thanks for your help! MaryBeth MaryBeth

Ian, It still only brings back the 1776. Mary MaryBeth

My apologies, I thought I had put it in the wrong category. Mary MaryBeth