Skip to Content
Former Member
Jun 22, 2009 at 01:48 PM

Aggregating invoices


Hi Guru's

Having a bit of a challenge aggregating Invoices - and need some help on it

Case: I have Invoices which in consist of several orderpositions - an invoice can consist of several ordrepositions. In rows I have invoice and ordreposition - in columns I have an invoice counter.

Problem: When making a counter for invoice - I am not able to consistantly reach the correct amount in the resultarea when making conditions. The result given is not restricted to the condition - but the result without any conditions. To solve the matter I tried calculating results as totals - this just resulted in me counting the amounts of invoicelines (as my view is set up to show that).

In short the question is - How do I calculate the correct total of invoices when I have conditons in the query?