BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

[BOBJ 4.x] Formula counting distinct even though I did not tell it to


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
volleyballtigger
Forum Member
Forum Member



Joined: 21 Nov 2018

Posts: 1



PostPosted: Wed Nov 21, 2018 12:03 pm 
Post subject: Formula counting distinct even though I did not tell it to

This is probably really easy, but I'm struggling. I have a list of cases by number. I want to summarize the number of cases, but I need a total count, not distinct. Duplicates should be counted. I used the formula =Count([Case Number]), and I'm getting the number 30 instead of 47. If I do =Count([Case Number];All) I get a count of 175. I have no idea where that is coming from. Any suggestions here? Everything I read online is that the formula is not supposed to do a distinct count unless you tell it to.
Thanks!!
Back to top
Bobo0540
Forum Member
Forum Member



Joined: 10 May 2019

Posts: 1



PostPosted: Fri May 10, 2019 4:35 pm 
Post subject: Re: Formula counting distinct even though I did not tell it

I don't have control over the back-end structures or settings in the instance of Business Objects that I am developing in, and the default unadulterated behavior for Count() behaves as count([ ];distinct), unless you indicate count([ ];all). So your experience is similar to mine.

I would suspect that perhaps there's an administrative layer option that may be able to change or set the default behavior for Count().
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0271 seconds using 17 queries. (SQL 0.0029 Parse 0.0008 Other 0.0233)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo