Please help find the bug

[sabavno]

Hi,

I have a simple formula that does not seem to work:

@If(RTransit = "80323";"07206";RTransit = "70207";"00275";@Trim(@LeftBack(Bill_To_Transit; 4))="9";"99999";"&quot

For the false case, RTransit shold be populated with blank "", but it never does.

However, if I change formula:

@If(RTransit = "80323";"07206";RTransit = "70207";"00275";@Trim(@LeftBack(Bill_To_Transit; 4))="9";"99999";"No&quot

Then "No" appears whenever false condition is met.

Please help.

Thanks

 

[kdunne]

I have found that once a field is populated with a value (I am using R5 and doing most of my work using the Web as my client), then I have to make the value " " (a space) rather than "" or it doesn't replace. I don't know if this could be it?

 

[ABOzIT]

Can you tell us a bit more about how you are using this formula? Is the RTransit field editable or computed. Is it text or number? Are you doing a refresh fields in a keyword change option in another field somewhere on the form.

This additional info might help determine why the field is not updating.

Cheers!