Weirdness

[Guest_imported]

Hi all,
Kinda weird problem,
I got this table
ID
---
a
b
c
---
=CountAll(<ID>) (answer 12,181)

Now, since I just want a count, I created a cell and put the same formula in.. voila! the answer is now 1. I tried using the 'In', 'ForAll' etc but to no avail. Can anyone help point me to the right formula please. Thanks!

 

[PAULSGS]

If you want to display the number of rows returned by your query, then you need the NumberOfRows function, e.g.

=NumberOfRows(DataProvider(<Name(Query 1 with KANA)>))



NumberOfRows is first function called
DataProvider is first parameter of NumberOfRows
Name is a variable from my data provider
Query 1 is Data provider identifier
KANA is connection identifier

If your posting is not about this but about the non-appearance of similar rows, which you want to show, then make the table active by clicking on a cell, then from the menu bar click Format->Table & check &quot;Avoid Duplicate Rows Aggregation&quot;

If your query is about contexts of formulas, please supply a fuller example with the answers that you expect

 

[blom0344]

Hello Agus,

The CountAll function in BO takes into account duplicates and empty cells in a range. It effectively does a row count in an table/crosstab. You can not get it to work in a free-standing cell, as opposed to the count function. It is not a matter of adding context, you have to use a bit of trickery for this one.

Create a copy of the table you want to do the CountAll on.
Do a CountAll on the object in the table (extra line appears under the table)
Go to Format Table and Pivot. Hide all colums accept the one you introduced CountAll on. Then go to General tab and choose 'Fold'. Effectively you have just a mini-table left of 2 cells. Change the header to text you want or delete it totally. The correct calculation still shows. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com