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: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Formula help - doing scoring


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



Joined: 10 Apr 2019

Posts: 3



PostPosted: Fri May 22, 2020 10:06 am 
Post subject: Formula help - doing scoring

Hi, I am trying to find a way to score a sentence. For example, "I have Diarrhea and Sore throat" may get a score of 6 but if "I have Diarrhea and Sore throat, and went to hospital" may get a score of 8...

I try doing a formula like the following:
If Match(Upper([Accident]);"*DIARRHEA*") Then 4
+ If Match(Upper([Accident]);"*SORE*") Then 1
+ If Match(Upper([Accident]);"*THROAT*") Then 1
+ If Match(Upper([Accident]);"*HOSPITAL*") Then 2

But it doesn't work... it stopped after the 1st condition is done. I have many key words, but I don't want to create many variables, what's other way to accomplish this?

Many thanks!!!
Back to top
n8aktiv
Principal Member
Principal Member



Joined: 28 Dec 2018

Posts: 116


flag
PostPosted: Sun May 24, 2020 1:25 pm 
Post subject: Re: Formula help - doing scoring

try to complete your if-statements with "else 0"
and add parenthesis if( ... then ... else ...)

_________________
------------------------------------------
SAP BO 4.2 SP6 Patch 10
------------------------------------------
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.0272 seconds using 17 queries. (SQL 0.0028 Parse 0.0008 Other 0.0236)
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