Sum of count

building reports webintelligence
1

Hi,

Am trying to get a total in a report without showing the detail.

Eg:

date Storecount
1/1/2011 100
1/2/2011 200
1/3/2011 250
1/4/2011 350
1/5/2011 300

The storecount should be 1200. however when I remove the date, the storecount it gives me a distinct count of stores across all business dates (1220 in this case). How do I go about it. I have tried sum(count([store]) foreach ([date]). Tried other variations too.

chirkutbhai (BOB member since 2007-08-09)

2

Do the extra 20 come up against a different business date? Can you apply a filter on the date?

nithya_raj (BOB member since 2007-02-03)

3

Hi,

if the formulae is not working , u can include the date column in report and hide the column(i.e minimize the column width, changing teh text color)

regards
GM

tgmurugan (BOB member since 2007-11-20)

4

Hi chirkutbhai,
Please try using alerters for hiding the column date.
You can overwrite StoreCount on date column with the use of alerter,which will not remove the date and offcourse will not change the count

swap_l (BOB member since 2009-04-09)

5

Hi Guys,

thanks to all for the prompt responses.

  1. I dont have a filter on date
  2. I just want to use the sum formula elsewhere in my report to do some calculations. I dont want to display it anywhere, Hence hiding the date column will not help.

chirkutbhai (BOB member since 2007-08-09)

6

Make sure the store count object is a measure and has Sum() around it and also that the aggregation type is Sum.
If your store count is a dimension, then make sure that you do not retrieve duplicate rows.

Mohan :us: (BOB member since 2002-08-15)

7

I need to check if the storecount for every business date meets a threshold else I need to display a message even if business date has low store count. I just need to display the message. I dont want to display the dates or the storecounts…
So for eg: If I have the following data and my threshold is 1200.

Date Storecount
1/1/2011 1300
1/2/2011 1100
1/3/2011 1400
1/4/2011 1200

In this case I will display a message since Storecount is below the threshold for 1/2/2011. As mentioned , I dont want to display the above data though… just flash the message.

chirkutbhai (BOB member since 2007-08-09)