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!

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

Recent content by billove

  1. billove

    Chart shows zero values from formula

    Works great, just what I needed! Thanks! I changed the formula to: If DistinctCount({JrnlRow.PostOrder}, {JrnlHdr.TransactionDate}, "monthly") = 0 Then 0 Else Sum ({JrnlRow.StockingQuantity}, {LineItem.ItemID}) / DistinctCount({JrnlRow.PostOrder}, {JrnlHdr.TransactionDate}, "monthly")
  2. billove

    Chart shows zero values from formula

    The information: I'm using Crystal Reports 9 for Peachtree. The report is titled Monthly Inventory Sales which has one parameter "Category". The first group is by "TransactionDate", monthly. The second group is by LineItem.ItemID which includes the Sum of JrnlRow.StockingNumber (Units Sold)...

Part and Inventory Search

Back
Top