Hi, we have a GI that shows Won opportunities per period. Beside the $ value, there is a value that counts how many documents consists of it. However, it adds 1 count to in pivot tables. I’ve used all aggregate functions in Pivot table and Count Distinct is the best option which is still not correct as the value is still one off. If this is not a limitation, how do I correct this?
Hi
Please upload your GI XML so I can verify and suggest you the solution. This will help to identify where is the exact issue.
However, it looks like not only that one off in the one cell which you have highlighted but it is 3 off in each line as the Count Total does not match for each line total. Looks like you are considering the whole numbers instead of starting from next number, meaning, you should have range like 0-25000, 25001-50000, 50001 to 100000, and so on to count. Please check the formula you have in GI and even for your $ value. Hopefully this resolves your issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
