Skip to Content
0
Former Member
Jul 15, 2011 at 04:36 PM

COUNTs and Calculations

12 Views

CR Xi

SQL 2005

I've created several Running Total fields such as #CountOpen; #CountCloseWon; #CountALL

#CountOpen has logic to check for if the opportunity is open {Table3.Status}='Open'; #CountClosedWon has logic to check for if the opportunity is closed and won {Table3.Status}='C-Won'; #CountAll is setup to count all rows (COUNT not Distinctt Count).

So, I've set these up, setup Formula fields for calculations but all I get are 0's in the Footer1 area.

@ClosingPercent={#CountClosedWon}*100/{#CountAll}

@ClosingRatio={#TotalSales}*100/#TotalOutstanding

Assume the #TotalSales and #TotalOutstanding work as these fields are on the report (Footer1) and have the correct data.

What am I doing wrong on the ratios and calculations? I've inserted the fields into the Detail section and Suppressed them so they don't print.

Seems like an easy solution.

Is there a way to step through the processing as a report runs?

TIA!