Skip to main content
Solved

Visible Expression

  • 20 December 2022
  • 3 replies
  • 410 views

Hello!

I have this visible expression here. What if I need to specify many values in this conditional statement, where or how should I place them? Thanks so much in advance!

 

@paula012 What do you mean by many values? Do you mean nested if or do you mean instead of ‘DP ...’ you want to have multiple strings?


@paula012

In case you need a nested IF you can use something like this.

=CBool(IIf([ARTran.TranDesc]<>'TEST1', ‘False’, IIf(IARTran.TranDesc]<>'TEST2', ‘False’, IIf(ARTran.TranDesc]<>'TEST3', ‘False’, ‘True’))))

 

If you want to compare a few texts and ignore them you can use InStr something like:

=CBool(IIf(InStr('|TEST1|TEST2|TEST3|', 1Address.DisplayName])<>0, ‘False’, ‘True’))

 

You might need to play a little bit with the formulas to get the desired result or switch the true to false. I am not an expert at RD but the above should give you a head start:


Hi sir @aaghaei , thank you so much for the reply. I tried a simple formula that worked, I used “AND” for each item that I don’t wanna display. I will also try what you gave to compare. But can you let me know which I should use? Seeing that I just want to add many items as ‘values’ I don’t want to appear. Would this shorter formula be alright? Thanks again!

 


Reply