Skip to Content

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

Counting values problem

Hi,

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.

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