on 09-11-2014 10:36 PM
Hello,
How can I make an interval condition in the ifthenelse function ?
I tried this : ifthenelse (variable = '[0-9]%', value, value).
But BODS returns a syntaxe error.
Does any one have an idea ?
Thank you for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If I am following your logic it appears that if the variable is between 0 and 9% you want to do the if?
Try this...
ifthenelse (variable >= '0%' and variable <= '9%', value, value).
post the sample query you are trying .... with sample data and expected result...
As far as my understand goes, you should try with true/false expressions like
(condition and condition) and (condition or condition).....
Can you show sample source data..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.