formula to show only counts greater than zero

[retygh45]

Using CR10, I have a report that shows the total for 10 different clients. Not all clients are active though.

I have 10 running totals, one for each client, but I'm trying to add a formula to my report footer to show which ones are active and not show ones that have a count of 0

So, my formula is

IF {#initial B&W} > 0 Then
{#initial B&W} & " B&W and "

So I have 10 {#initial xxx} and I want to have 1 formula showing their counts if they're greater than 0, and leaving them out of the formula if they're 0.

Any help is greatly appreciated, thanks!

 

[MCuthill]

retygh,

Assuming I understand you correctly, could you not structure the report to be grouped on the client info (a customer # perhaps) and have totals for each group?

You could then create a formula field to display Active or Inactive based on the total of these group summaries. Another option may be to put it into the group selection formula to remove any groups where the total count is 0.

I hope I understood your needs correctly.



Mike
______________________________________________________________
"It Seems All My Problems Exist Between Keyboard and Chair"

 

[lbass]

You should be able to create a formula like the following--as long as the running totals are never null:

(
IF {#initial B&W} > 0 Then
(
totext({#initial B&W},2) + " B&W and "
)
) +
(
IF {#second RT} > 0 Then
(
totext({#second RT},2) + " OtherName and "
)
) +

//etc.

Not sure how you want the rts formatted, but by using all strings, the default will be "" for the relevant clause.

-LB