Formula Help

[danielw]

I have the following formula in my report.

if ({Weights.Account} = ["ges2","fr2"]) then {@charge4} else 6

I want the formula to work if I have any weight.account with a 2 at the end of account name Ie ges2,fr2,jj2. Now I have to put each account in between brackets like above for this formula to work.

Thanks
Daniel

 

[dgillz]

if right(({Weights.Account},1)="2" then {@charge4} else 6

Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[danielw]

Thanks dgillz that was what I needed.

Daniel