Please help find the bug
Please help find the bug
(OP)
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";"")
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")
Then "No" appears whenever false condition is met.
Please help.
Thanks
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";"")
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")
Then "No" appears whenever false condition is met.
Please help.
Thanks
RE: Please help find the bug
RE: Please help find the bug
This additional info might help determine why the field is not updating.
Cheers!