Skip to main content
A
Anonymous
November 2, 2020

If statement in report books

  • November 2, 2020
  • 1 reply
  • 0 views
Originally posted by Bob Nelson

When using an If statement inside of a loop the reference guide only shows example of = and <>.  Are there other conditional statements that are supported by an If statement in report books.  Specifically I am looking for "contains" a certain text string or "does not contain" a certain text string.  I'm also open to using a Right command to parse the Loop variable as in if Right(loop variable, 4) <> "_USD".  

 

Thank you,

1 reply

T
TonyToniTone
September 13, 2021

If Statements inside of a loop can use all the operation and conditional statements that are used for conditional formatting within Cube Views.  The following conditional statements can be used for Books:

StartsWith

Contains

DoesNotContain

EndsWith

In 

NotIn

Or

And

tdimitrie_0-1631573212259.png

 

Terms & ConditionsAccessibility statement