Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Counting values problem


I've a report in the BO XI web interface.

There is a page in the report wich contains a table with the data from the query with a simple filter on in.

The filter sais: Type = "FM".

It works fine.

I've also created a count below with the following formula: =Count([Cost]) where ([Cost] = 0)

It gives me 162. All correct.

There is another page. With a new block with the same filer. With several fields with formula's like:

=Count([id]) gives me 404

=Count([id]) Where (IsNull([Problem])) gives me 320.

All correct, but when i create the same formula as in the other page it gives me 0. I tried some other formula's but it doesn't work. I simply want the number of fields with 0 in it:

=Count([Cost];all) gives me 1

=Count([id];All) gives me 808

=Count([id]) gives me 404

=Count([Cost]) where ([Cost] = 0) gives me 0

=Count([id]) Where ([Costs] = 0) gives me a blank field

How can I count all the records with Costs = 0 and why does it work in the other page, but dosn't it work on this page.

Not what you were looking for? View more on this topic or Ask a question