Solved

Visible Expression

  • 20 December 2022
  • 3 replies
  • 345 views
P
Rank
Userlevel 3
Badge +1

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!

 

icon

Best answer by aaghaei 20 December 2022, 08:17

View original

3 replies

aaghaei
Rank
Userlevel 7
Badge +8

@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?

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
aaghaei
Rank
Userlevel 7
Badge +8

@paula012

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

=CBool(IIf([ARTran.TranDesc]<>'TEST1', ‘False’, IIf([ARTran.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|', [Address.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:

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
P
Rank
Userlevel 3
Badge +1

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


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved