include if

[soniasweety]

Hi all,

I have expression  like below but I want to write the if condition  in backend how can I write?

this is original expression  = Only({$-<compltedate={"*"}>}id)

tried in script   if( Only({$-<compltedate={"*"}>},'Yes','No') as NewID

what is wrong in this expression can anyone give suggestions?

[prma7799]

Put value in Variable like

vNewVariable = Only({$-<compltedate={"*"}>}id)

And use in front end like

if( $(vNewVariable ) ,'Yes','No')

[soniasweety]

not working

after using the variable

giving error when I debug it is showing like this   --error  ')' expected

[prma7799]

Can you please share some sample app.

[Chanty4u · Accepted solution]

or else

try in simple way   which field your excluding null use that in same expression like below

=Aggr(only({<Flag1={0},Status-={'passed'}, Completedate-={' '}>} if(duration>=Critical,id,null())),id,Name)

[soniasweety]

yes chanty it worked thank u