Formula counting distinct even though I did not tell it to

building reports desktopintelligence
1

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!!

volleyballtigger (BOB member since 2018-11-21)

2

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().

Bobo0540 (BOB member since 2019-05-10)