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)
Group Name MONROE
text GENERAL field name value 122
SPECIAL 0 (*)
LIMITED 2
TOTAL suppress 124 to show (*)
so they cant had the numbers to have the TOTAL value
Group Name JOHNSON
text GENERAL field name value 122
SPECIAL 4
LIMITED 2
TOTAL 128
now there are no 0 or null value assing to then show the TOTAl value
Group Name WADE
text GENERAL field name value 99
SPECIAL 0 (*)
LIMITED 0 (*)
TOTAL 99
now i have more than one 0 or null value then Show the TOTAL value
NOTE: EACH OF THESE FIELDS NUMBERS ARE THE SAME NAME ASSIGN TO EACH DISTRICT BUT CONTAINS DIFFERENT VALUE IN REPECT OF THE DISTRICT NAME
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 one (*) or 0 then show the value of TOTAL
now remember that i have multiple district and all have diferent value not all district have 0 or is null assing to the repected field
I just want to replace the distinct districts that has the 0 or is null value
thanks
PG
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)
Group Name MONROE
text GENERAL field name value 122
SPECIAL 0 (*)
LIMITED 2
TOTAL suppress 124 to show (*)
so they cant had the numbers to have the TOTAL value
Group Name JOHNSON
text GENERAL field name value 122
SPECIAL 4
LIMITED 2
TOTAL 128
now there are no 0 or null value assing to then show the TOTAl value
Group Name WADE
text GENERAL field name value 99
SPECIAL 0 (*)
LIMITED 0 (*)
TOTAL 99
now i have more than one 0 or null value then Show the TOTAL value
NOTE: EACH OF THESE FIELDS NUMBERS ARE THE SAME NAME ASSIGN TO EACH DISTRICT BUT CONTAINS DIFFERENT VALUE IN REPECT OF THE DISTRICT NAME
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 one (*) or 0 then show the value of TOTAL
now remember that i have multiple district and all have diferent value not all district have 0 or is null assing to the repected field
I just want to replace the distinct districts that has the 0 or is null value
thanks
PG