Formula for field that contains or ends with DP or AD

[crystalpro]

I need to be able to get invoice amounts for invoices that have an invoice number that ends with "DP" or "AD". The invoice number may be 4,5, or 6 characters followed by DP or AD. If the invoice ends in DP, I want crystal to multiply an amount field by -1. If the invoice ends in AD, then I want crystal to just use the amount field.

The formula looks something like:
If {JrnlHdr.Reference} ??????(ends with DP) then
{JrnlRow.UnitCost} * -1
else
if {JrnlHdr.Reference} ??????(ends with AD) then
{JrnlRow.UnitCost}
else 0

 

[MJRBIM]

Trim the string using the right command....

If Right({JrnlHdr.Reference}, 2) = 'DP' then
{JrnlRow.UnitCost} * -1
else
if Right({JrnlHdr.Reference}, 2) = 'AD' then
{JrnlRow.UnitCost}
else 0

That should do it.

 

[synapsevampire]

Try:

If right(trim({JrnlHdr.Reference}),2) = "DP" then
{JrnlRow.UnitCost} * -1
else
if right(TRIM({JrnlHdr.Reference}),2) = "AD" then
{JrnlRow.UnitCost}
else 0

-K

 

[Reebo99]

If right(trim({JrnlHdr.Reference}),2) in ["DP","AD"] then
{JrnlRow.UnitCost} * -1 else 0


Reebo
Scotland (Sunny with a Smile)