I have a 12 Summary fields in my Group footer Jan_Total to Dec_Total amounts.

Then I have created formula as f_Tot_Orig_Amt. and added 12 summary fields to get Year total.

But in some groups all 12 totals are 0 so my Year_Total also zereo. But the requirement is that If all are zero there is no need to display that group. How can I filter.

I am trying to put a condition in select expert on formula field (as f_Tot_Orig_Amt )I have created , but this formula field is not visible in select expert.

How can I see the formula field in section expert? So that I can put a condition like this

as f_Tot_Orig_Amt  != 0 (not equal to)

or is there any other way to do this?

-nb