Grouping and counting measure objects

building reports desktopintelligence
1

Hi–

I have a series of formulas that gets me to a final result in the Bus Obj User application. Now I want to count all the like values from that final result. Example of values in the “Final Result” 110
110
234
99
456
456
110

I need to see from splice and dice (or somewhere) the data grouped and counted as in the example below
110 3
234 1
99 1
456 2

All I am getting for each value, even when it repeats such as 110 is a 1 in the “count” field. I have tried to make a variable that counts the “final result”, tried to use the count function from splice and dice, etc.

I think the problem may be that my “final result” is a measure object and the COUNT function only counts unique value for dimension and detail objects.

Question: How can I group and count my “Final Result” field?

You folks are continually bailing out of my dilemnas and I thank you in advance for any help you can offer me.

–Beverly

Listserv Archives (BOB member since 2002-06-25)

2

Which version of BusObj are you using?

If it’s 5.0, there should be a CountAll choice that counts duplicates.

If it’s 4.1.x, then you need to do a secondary count. Change your counting measure object (e.g., “=Count()”) so it looks like “=Count(Count())”. It will then count duplicate values.

George Baranowski
QuadraMed

Listserv Archives (BOB member since 2002-06-25)