If statement

259
2
Jump to solution
01-05-2022 12:33 PM
GaryBowles1
Occasional Contributor III

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

 

Tags (3)
0 Kudos
1 Solution

Accepted Solutions
Katherine_Clark
MVP Regular Contributor

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!

View solution in original post

2 Replies
Katherine_Clark
MVP Regular Contributor

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
Occasional Contributor III

That worked.

Thanks!!

--gary

0 Kudos