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: Upcoming Events: BI & HANA 2018 Prague: Jun 29.

Problem with creating an "easy" formula


 
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
walkyries93
Forum Member
Forum Member



Joined: 13 Jun 2018

Posts: 4



PostPosted: Wed Jun 13, 2018 10:59 am 
Post subject: Problem with creating an "easy" formula

Hi everyone,

I'm facing a problem since a few days to create a variable which could seems easy.

To make it simple, I have 3 columns: Id company, Sales, and the variable [V_Sales_Slices] which divides the company according to their sales (<50k; between 50-100k; >100k)

What I want is to count the number of companies in each slice in the same table.

My variable is : =Count([company]) in([V_Sales_Slices])
But it gives me the total of companies..
How to make it count the number of companies but for each range ?

Is there an operator to do it?

Thank you for your help!
Back to top
anil.ganga1
Principal Member
Principal Member



Joined: 04 Jul 2007
ASUG Icon
Posts: 458
Location: San Francisco


flag
PostPosted: Wed Jun 13, 2018 3:02 pm 
Post subject: Re: Problem with creating an "easy" formula

Instead 'In' try 'ForEach' and see.
_________________
Thanks,
Anil.

Business Objects 6.5/XIR2/3.X/4.X
Crystal Reports 9/XI/XIR2/XIR2A/2008/2011/2013/2016
Back to top
walkyries93
Forum Member
Forum Member



Joined: 13 Jun 2018

Posts: 4



PostPosted: Thu Jun 21, 2018 8:40 am 
Post subject: Re: Problem with creating an "easy" formula

Thank for your help.
Here is my solution:

=If [V1]="<50k" Then count([Companies]Where([V1]="<50k")) ElseIf ... and the same for the other ranges

icon_smile.gif
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.0104 seconds using 17 queries. (SQL 0.0022 Parse 0.0002 Other 0.0081)
CCBot/2.0 (http://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