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 dencom 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: *

  • Users: nugget5
  • Content: Threads
  • Order by date
  1. nugget5

    Conditional average

    My datasource brings back a row showing a monthly summary for each user for the last 12 months. I am trying to get an average of the Number of Days Worked for the current month. Here is my formula: whileprintingrecords; average({ds.daysworked}, {ds.WorkMonth}, Month (CurrentDate)) I know this...
  2. nugget5

    Getting monthly totals when there is no activity

    I have a view (vMonthlyBalSheet) that totals user activity by month SELECT UserID, DATEPART(yy, ActivityDate) AS ActivityDateYear, DATENAME(m, ActivityDate) AS ActivityDateMonth, COUNT(*) AS DaysWorked, SUM(Offage) AS NetCashVar, SUM(UnitsSold) AS TotalSold FROM vBalanceSheet GROUP BY...
  3. nugget5

    Rows for Months with No data

    I am creating a report that shows monthly totals for users. The view that is supplying the data has monthly aggregation done. The problem I am encountering is if a user did not work in a certain month there is not a row for that month. Is there a way I can display a row that would show zero...

Part and Inventory Search

Back
Top