IF expression not generating correct result

[Daisy_Ramirez]

I have the following IF Expression that’s generating a “0” result but when I review the conditions they’re being met successfully and the expression should not be generating “0”. We’ve not had an issue with this expression in the past but today the client reports the 0.

The formula below represents the Total Mileage in the screenshot and you’ll see the results for the IF expression in the TEST_STARTCITYSTATE and TEST_CITY_DATE_DEST fields in the screen shot as well.

Is there a more effective way to write this expression for the accurate calcuation?

Thanks so much

[Steve]

I’d have to assume [vir_distance] is 0.

[Daisy_Ramirez]

It is 233.

Ok this is odd. I just checked the screen and synchronized again and now I have the correct mileage. I’ve been synchronizing while working on this issue for over an hour and a half. Possibly had to regenerate the table or some delayed calculation?

Its working though. Thanks as always Steve.