Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Supress if number does not end with a 1
- Thread starter Fadius
- Start date
Fadius,
Your suppression formula would look like:
There may be a cleaner approach, but this worked in my testing.
Cheers!
Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
Your suppression formula would look like:
Code:
Right(ToText(Int({YourSUMField),0,""),1)=1There may be a cleaner approach, but this worked in my testing.
Cheers!
Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question