Search results for query: *

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

Ian, vpg: whileprintingrecords; shared Currencyvar totala; shared numbervar tourb; currencyvar VPG; VPG := if tourb = 0 then 0 else totala/tourb; VPG i have this in the sub looking at the main report field totala and tourb Thanks, Mary MaryBeth

I just tried that and if tells me the field can't be summarized? MaryBeth

Unfortunately no. I added an additional footer and placed it there and it still picks up only the second record for a total. Here's my formula for vpgpass in subreport: whileprintingrecords; shared currencyvar vpgpass := {@VPG} here's the one in my main report avgvpg...

have a report with a subreport. The sub report is grouped by empid and payweek. the main report is also grouped the same way. I created a formua in the sub that passes to the main. On the main report it calculates correctly for each empid and payweek. My problem is when I try to add the...

I have a report with a subreport. The sub report is grouped by empid and payweek. the main report is also grouped the same way. I created a formua in the sub that passes to the main. On the main report it calculates correctly for each empid and payweek. My problem is when I try to add the...