I am trying to use the count function to count characters on an object with a formula but it keeps equalling to 1. Also another formula using the count function, it counts incorrectly. I’m using “if” statements to calculate objects.
Khanh
Listserv Archives (BOB member since 2002-06-25)
In the Formula Bar, add count() around the original count. For example, if the original count reads:
count(<name of object)
Add count()so it looks like:
count(count(<name of object))
The “count of a count” will count duplicate values.
George Baranowski
QuadraMed
Listserv Archives (BOB member since 2002-06-25)
If you are using ORACLE, i would imagine the LENGTH function would be more suited to the task that you have described. COUNT is a group function which means that it is not suitable for the purpose of calculating the number of characters in an object.
Paul Jarrett
Business Objects Developer
Gamar Limited
United Kingdom
I am trying to use the count function to count characters on an object with a
formula but it keeps equalling to 1.
Listserv Archives (BOB member since 2002-06-25)
George,
The Count(Count(name of object)) gives me a syntax error. I also tried to Countall(count(name of object)) and it still comes up with 1. Any other ideas?
Khanh Dang
AirTouch
In the Formula Bar, add count() around the original count. For example, if the original count reads:
count(<name of object)
Add count()so it looks like:
count(count(<name of object))
The “count of a count” will count duplicate values.
Listserv Archives (BOB member since 2002-06-25)
What type of object are you counting?
By the way, the text in the Formula Bar must be preceded by “=”:
=count(Count())
George Baranowski
QuadraMed
Listserv Archives (BOB member since 2002-06-25)
Count() or count() will count unique values. In other words, count on a column that includes three different values on 100 different rows will return 3. There are 3 different values. If you count() then that counts the number of rows instead.
If you are using v4, you can try the formula =count(body). Note that there are no brackets <> around the word “body”. Body is a keyword that translates to “rows”, essentially.
If you are using v5, you have a new option: countall(). Countall() ignores duplication and counts the rows of data. However, this only counts the number of displayed rows, not the number of rows from your query.
If you need to know the absolute number of rows that were returned from the query, use the formula =NumberOfRows() instead of a count. Even if the report is showing summary data, the NumberOfRows() function should return the absolute number of rows of data.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)