Information générale
Catégorie:
Gestionnaire de rapports & Rapports
I have a report that performs a calculation in the summary band. The calculation is sum(max_credit) - sum(sales_amt). There is a one to many relationship between Max_Credit and Sales_Amt. Max_Credit is at the Customer level and the Sales_Amt is at a lower level. Meaning that a straight sum(Sales_Amt) will work but I only want to sum the Max_Credit when the Name changes - for each unique name.
How is this accomplished?
Name,Max_Credit, Sale_Amt
smith,1000.00,50.00
smith,1000.00,75.00
johnson,2000.00,35.00
taylor,500.00,25.00
taylor,500.00,55.00
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement