If statement

[GaryBowles1]

I am trying to calculate a yes or no answer for a field using the formula below. 

if((string-length(${inbox_flag})=5,"yes" and string-length(${leak_tagno})>0,"yes"), 'yes', 'no')

I keep receiving invalid result and have been banging my head against the wall all afternoon. What am I doing wrong?

Thanks,

--gary

[Katherine_Clark · Accepted solution]

Hi Gary,

This worked for me:

if((string-length(${inbox_flag})=5 and string-length(${leak_tagno}) > 0), 'yes', 'no')

You had extra "yes" statements in there that weren't needed. Hope it makes sense!

[GaryBowles1]

That worked.

Thanks!!

--gary