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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excluding null value in a string

Status
Not open for further replies.

BlurredVision

Technical User
Aug 6, 2001
326
GB
I am attempting to get a minimum total going on a string field. There are some null values within the string field which mess up my minimum total. Is there a way around this?

Thanks for your time...
-=- Brian -=-
 
not sure how you are going about this but to eliminate NULLS

use: {@fieldtest}
*****************************************************
if not isnull({table.field}) then
{table.field}
else
""; //put a value here tah does not interfere with
your minimum calc

*************************************************

then you can do a summary on this field

minimum({@fieldtest})
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top