Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. marylally

    Formula in Group Footer adding prior value

    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...
  2. marylally

    Formula in Group Footer adding prior value

    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...
  3. marylally

    Formula in Group Footer adding prior value

    It works but not on every one.? MaryBeth
  4. marylally

    Formula in Group Footer adding prior value

    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
  5. marylally

    Formula in Group Footer adding prior value

    THanks! That worked! Much appreciated Mary MaryBeth
  6. marylally

    Formula in Group Footer adding prior value

    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...
  7. marylally

    main report not adding subreport totals by groups together

    I added another section, should I delete it? MaryBeth
  8. marylally

    main report not adding subreport totals by groups together

    Sorry, Group Footer 3 MaryBeth
  9. marylally

    main report not adding subreport totals by groups together

    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
  10. marylally

    main report not adding subreport totals by groups together

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

    main report not adding subreport totals by groups together

    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...
  12. marylally

    main report not adding subreport totals by groups together

    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...
  13. marylally

    main report not adding subreport totals by groups together

    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
  14. marylally

    main report not adding subreport totals by groups together

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

    subreport total to main

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

    main report not adding subreport totals by groups together

    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
  17. marylally

    main report not adding subreport totals by groups together

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

    main report not adding subreport totals by groups together

    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...
  19. marylally

    subreport total to main

    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...
  20. marylally

    main report not adding subreport totals by groups together

    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...

Part and Inventory Search

Back
Top