BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

[BOBJ 6.x] If And Statement


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
vitordf59
Forum Member
Forum Member



Joined: 28 Aug 2015

Posts: 6



PostPosted: Thu Jan 03, 2019 10:11 am 
Post subject: If And Statement

Hi,

Trying to create a variable something like:

If( Table 1[columnA] >= 0 and Table 1[columnB] <= 30 then "pot1" else "NA")

but for some reason is not working, what am I doing wrong?

Thanks in advance,

Any help and all help is very much appreciated
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11382
Location: Manchester, UK


flag
PostPosted: Fri Jan 04, 2019 4:15 am 
Post subject: Re: If And Statement

Firstly, are you on 6.x Desktop Intelligence or Webi?

Secondly, in what way is it not working?

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6555
Location: Connecticut, USA


flag
PostPosted: Fri Jan 04, 2019 4:09 pm 
Post subject: Re: If And Statement

Query names need to be bracketed too:
If( [Table 1].[columnA] >= 0 and [Table 1].[columnB] <= 30 then "pot1" else "NA")
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0286 seconds using 17 queries. (SQL 0.0031 Parse 0.0009 Other 0.0245)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo