Counting Certain Records Twice: continuation of THREAD 767-1342545

[elansienna]

Hello All,

I’m trying to do something similar to thread 767-1342545 where I am also counting certain records twice. I found this thread very useful in constructing the formulas.

My formulas read as follows:

@New
if {TABLE.OPEN_TIME} in Minimum({?Date}) to Maximum({?Date}) then 1

@Closed
if {TABLE.STATUS}="closed" then
1

@Open
if {TABLE.STATUS}="open" and {Table.OPEN_TIME} = Maximum({?Date}) then
1

This is a report (driven by date param) where I need to count the number of "new" (tickets created in the date parameter range), "closed" (tickets that were closed in the date parameter range) and "open" (tickets that were open on the last day of the date parameter range).

My problem is that I'm using a chart to show the totals, but can't seem to get the totals to show (no chart shows). I selected "for all records" and sum each formula in the show values field. I even selected "for each record" with the fomulas in the show values field, but it does not allow you to summarize the formula.

I don't know what to do at this point. I'd appreciate any suggestions. Thanks.

 

[elansienna]

Thanks to whomever was attempting to help with this post, but I figured it out! It had been a long day.

 

[lbass]

You should explain what you did, so that others can learn from your thread.

-LB

 

[elansienna]

Sure lbass, as I have certainly received great tips from you and this forum! As you suggested in the referenced thread, I created three separate formulas to capture, "new", "closed" and "open" tickets and placed each in the detail section to get an increment count and suppressed each so that the numbers would not show. I then created a grand summary for each and placed in the report footer, also suppressed. I used these summations in the show values section of my chart "for each record.