If a field is null, I want to replace it with "In Transit" else the field. I have tried various syntax to no avail. The "In Transit" does not appear in the report for blank warehouse city.
I have Default Values For Nulls selected
Formula below:
if isnull({IM_Warehouse.WarehouseCity})then "In Transit" else {IM_Warehouse.WarehouseCity}
Can you please assist? Thanks very much.
I have Default Values For Nulls selected
Formula below:
if isnull({IM_Warehouse.WarehouseCity})then "In Transit" else {IM_Warehouse.WarehouseCity}
Can you please assist? Thanks very much.