Formula HELP ASAP !!!

[pgtek]

Hello,
Can you help me please, heres my problem
i have a group call district and in this group i list multiple district
each district has 4 field (number)

GENERAL
SPECIAL
LIMITED
TOTAL
if one of these field is 0 or is null suppress it and replace with a (*)
now heres the tricky part
if one of these field is 0 or is null then the TOTAL field replace it with a (*) so the cant add the sum of these field to have the TOTAL value
else if
i have more than 1 (*) or 0 then show the value of TOTAL
now remember that i have multiple district and all have diferent value not all have 0 or is null
I just want to replace the distinct districts that has the 0 or is null value

thanks

PG

 

[synapsevampire]

It's a bit unclear what you, though thsi might help:

Create a formula to use as the group:

If isnull({MyTable.District})
or
{MyTable.District} = "" then
"Other"
else
{MyTable.District}

As for eliminating rows from the report, try to do this in the record selection criteria.

Post sample data and expected results and someone can work it out.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com