11-02-2020 11:51 AM - last edited on 08-11-2023 10:55 AM by JackLacava
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,
09-13-2021 06:52 PM
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