If statement in report books

OSAdmin
Valued Contributor
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 1

TonyToniTone
Contributor II

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