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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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")- billove
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
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)...- billove
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
