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.

How to calculate difference between Revenue based on years ?


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



Joined: 13 Feb 2012

Posts: 54



PostPosted: Mon May 21, 2012 8:46 pm 
Post subject: How to calculate difference between Revenue based on years ?

Hi All,

How do i find out the difference between Revenue based on years?
I want this dynamic so in future if any user wants to see the difference between revenue as he wants based on years...

Thanks
Back to top
bob2210
Forum Associate
Forum Associate



Joined: 23 Sep 2010

Posts: 679



PostPosted: Mon May 21, 2012 11:07 pm 
Post subject: Re: How to calculate difference between Revenue based on yea

Try This:

Prompt user to enter Start Year and End Year.

Use below logic:
Code:

([Revenue] Where ([Year]=UserResponse('Enter End Year'))) -
([Revenue] Where ([Year]=UserResponse('Enter Start Year')))
Back to top
reena19
Senior Member
Senior Member



Joined: 13 Feb 2012

Posts: 54



PostPosted: Tue May 22, 2012 12:07 am 
Post subject: Re: How to calculate difference between Revenue based on yea

thanks for reply but it did not work.... icon_sad.gif
Back to top
anushjay1521
Principal Member
Principal Member



Joined: 12 Jan 2011

Posts: 119



PostPosted: Tue May 22, 2012 12:56 am 
Post subject: Re: How to calculate difference between Revenue based on yea

Hi,

Not Working?? Did you get any error?
Back to top
reena19
Senior Member
Senior Member



Joined: 13 Feb 2012

Posts: 54



PostPosted: Tue May 22, 2012 1:56 am 
Post subject: Re: How to calculate difference between Revenue based on yea

when i inserted the formula it showing formula value in all cells and not asking for user response...

Last edited by reena19 on Tue May 22, 2012 2:00 am, edited 1 time in total
Back to top
anushjay1521
Principal Member
Principal Member



Joined: 12 Jan 2011

Posts: 119



PostPosted: Tue May 22, 2012 1:59 am 
Post subject: Re: How to calculate difference between Revenue based on yea

Not asking for user response??
Did you create the prompts Start Year and End Year?And then try refreshing the query the user will be prompted to enter the values. Then user entered values will be reflected in the variable created..

HTH...

Regards,
Anush
Back to top
dopple
Principal Member
Principal Member



Joined: 19 Jun 2009

Posts: 197
Location: Edinburgh


flag
PostPosted: Tue May 22, 2012 2:31 am 
Post subject: Re: How to calculate difference between Revenue based on yea

Just to clarify on this, the prompts would be 'Enter End Year' and 'Enter Start Year' based on the logic provided.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web 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.0284 seconds using 17 queries. (SQL 0.0030 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