Skip to Content
0
Jul 27, 2016 at 01:01 PM

Replace Blank/Empty value with NODATA

1939 Views

I tried the formula to remove blank/empty value from the table below.

But seem not working. Any advice to remove blank/empty value.

=[HISTORIC PRODUCT] Where ( [HISTORIC PRODUCT] <> " ")

I know it can be done with adding the report filter but I need through formula

Attachments