Skip to Content
0
Former Member
May 20, 2010 at 01:30 PM

Only Display if StartsWith is not True

61 Views

I'm trying to only display fields that do not start with a zero.

I played around with the formula below, but it of course returns a bunch of blank rows because of my "". Any help or suggestions would be GREATLY appreciated.

if {field} startswith "0" then "" else {field}