Skip to Content
0
Former Member
Dec 13, 2009 at 08:09 PM

CONDITIONAL FORMULA

29 Views

Using Crystal XI, I need to create a formula to determine if the last 4 fields of a 30 field string contains 'PR' then the field is blank or 0, otherwise if the last 4 fields do not contain PR then my field would = my formula @AO. It seems easy but this is what I've tried and it isn't working: if "PR"in{IV00101.ITEMNMBR} [27-30] then 0 else{@AO}

Thanks,

Jayne