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?