Hi, Working in SAP BusinessObjects Analysis for Office v 2.4.0.65048 and have spent a lot of hours trying to figure out the following:
I need to calculate the number of "Invoices with Order" and the number of Invoices without orders ("Wild Invoices") per vendor and department, as you can see in the attached image. The SUM of the value is calculated but I also need to sum up the count. Any help appreciated.
- SAP Managed Tags:
Accepted Solutions (0)
Answers (5)
Mats - it looks like he is showing you the Properties of the key figure in the BEx Query Display panel - and recommending that you adjust the settings there:
Hi,
use exception aggregation on count value :
Regards,
Anand
Thx Tammy, Well the problem is that I need to get the COUNT result integrated in the sheet in the same way as value is calculated, ie summed up per (i) Spend Stream, (ii) Supplier, (iii) Department and that it adopts accordingly every time I update the time range. So I started by adding (the yellow) columns with a BOOLEAN expression in order to populate each row with a 1 when there a value in the cell. But the problem is that the Result rows are also following the BOOLEAN calculation and do not understand it should count the sum instead.
So the overview should look like this:
And when I expand the rows to show the details it shall look like the figure below, ie where the 7 invoices in total for Vendor C are summed up separately per Vendor and per Department and site:
But instead in reality it look like below……with no sum of the count values....:-(
Hi Mats - would an =COUNT formula work?
See below screen shot:
| User | Count |
|---|---|
| 78 | |
| 9 | |
| 9 | |
| 7 | |
| 7 | |
| 6 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.