Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago

If statement in report books

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,

Books

1 Reply

Sort By
  • TonyToniTone's avatar
    TonyToniTone
    Contributor II
    4 years ago

    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