help with if then else 1

[ginkoba]

I created 2 optional parameters and have a couple of formulas for the user to either enter something or leave blank. They both work separately but wanted to combine them into one formula. Please see example below. When I put an else between the 2 formulas, it ignores the 2nd one. Can someone please assist?

if not (hasvalue(({?Status}))) or ({?Status}) = " " then True
else if
hasvalue({?Status}) then
{RIM_RISKS_AND_ISSUES.STATUS_CODE} in {?Status}
Else
if not (hasvalue(({?ProjectID}))) or ({?ProjectID}) = " " then True
else if
hasvalue({?ProjectID}) then
{INV_INVESTMENTS.CODE} in {?ProjectID}

 

[IanWaterman]

If this either of the first two are true than it stops

Try

(if not (hasvalue(({?Status}))) or ({?Status}) = " " then True
else
if hasvalue({?Status}) then
{RIM_RISKS_AND_ISSUES.STATUS_CODE} in {?Status})
and
(if not (hasvalue(({?ProjectID}))) or ({?ProjectID}) = " " then True
else
if hasvalue({?ProjectID}) then
{INV_INVESTMENTS.CODE} in {?ProjectID} )

Ian

 

[ginkoba]

Thanks Ian. You're freaking awesome. Somehow I missed a combination. It works!