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

Field Value contains "U"

Status
Not open for further replies.

davismar

IS-IT--Management
Apr 1, 2010
85
0
0
US
Crystal Reports XI.

I have a field name = tbl.InvoiceDetail.ItemID

What I need to do is this:

If the the above field name "contains" a "U" , I need to have the result of my formula (@TotalCOGS) * .80 for those item ID's that contain the U.

Can someone please help me write this?

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top