Field Value Contains U

[davismar]

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!

 

[lbass]

if instr({tbl.InvoiceDetail.ItemID},"U")<>0 then
{@TotalCOGS} * .80 else
{@TotalCOGS}

-LB

 

[davismar]

lbass,

Thanks for your help.

I tried this formula and receive the following error message:

---------------------------
Crystal Reports
---------------------------
{tbl.InvoiceDetail.ItemID}

This field name is not known.
---------------------------

---------------------------

What am I doing wrong? I copied it just as you have it?

Thanks!

 

[lbass]

I just copied YOUR field as shown in the first thread. Use your itemID field there instead--just add it in from the field list.

-LB

 

[davismar]

Thank you for your quick reply.

The field name is correct, but it still doesn't work.
Could something else be wrong?

Thanks

 

[davismar]

Note - this field name is a "string" value.
Does that make a difference?

Thanks,

 

[davismar]

Sorry - it seems to be working now.
Sorry again.
Thanks!