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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

WebI formulas to Lumira


 
Search this topic... | Search Lumira / Visual Intelligence... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Lumira / Visual Intelligence  Previous TopicPrint TopicNext Topic
Author Message
waterphone
Forum Member
Forum Member



Joined: 28 May 2019

Posts: 1



PostPosted: Tue May 28, 2019 9:14 am 
Post subject: WebI formulas to Lumira

Hello,

I have a report with WebI with a variable created from one of the dimensions. I am trying to do the same on Lumira but I am struggling. In WebI the formula would change the dates to just year depending on where the dates lie into a new variable.
Can anyone advise how I would do the calculation in Lumira? Going through the functions I have not seen one similar to Between that can be used in WebI

=If[Date] Between('01/01/2000;'31/12/2001) Then "00/01"
ElseIf [Date] Between('01/01/2001';'31/12/2002') Then "01/02"

Thanks for the time and help.
Back to top
katullus
Forum Associate
Forum Associate



Joined: 21 Aug 2009
ASUG Icon
Posts: 793
Location: NYC always in my heart


flag
PostPosted: Wed Jul 24, 2019 4:35 pm 
Post subject: Re: WebI formulas to Lumira

Hi waterphone,

And WELCOME TO B icon_mrgreen.gif B,

Are you using Lumira Designer or Discovery?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Lumira / Visual 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.0280 seconds using 18 queries. (SQL 0.0032 Parse 0.0009 Other 0.0239)
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