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

Register | Login 

Sunset Ride 
Sunset Ride 

BOB has retired moved! Our current platform (the one you are reading right now) is over 18 years old. Rather than continue here, the community has moved to a new software platform! We are excited about the move and hope that you'll come with us.

The new community URL is https://bobj-board.org/.

User accounts have not been converted. In order to participate on the new platform you will need to create a new account. Existing posts have been retroactively assigned to your user name, but are associated with an anonymous account. No personal information (email address and so on) has been transferred to the new platform.

If you have any questions, the "About BOB" forum will remain open for the remainder of 2020, at which point it will be replaced by a static page directing folks to the new community.

Thank you for your support and participation for the past 18 years.

Return a value based on 2 other values


 
Search this topic... | Search About BOB... | Search Box
Register or Login to Post    Forum Index -> About BOB  Previous TopicPrint TopicNext Topic
Author Message
estanford
Forum Member
Forum Member



Joined: 07 Aug 2018

Posts: 11



PostPosted: Thu Apr 01, 2021 4:23 pm 
Post subject: Return a value based on 2 other values

My client has a report with ID, multiple HCPCSs codes with associated values. there are many IDs in the report. They want to select the HCPCS code associated with the highest value for each ID.
ID HCPCS Value
1 1234 50
1 5678 100
1 3478 25

For each ID they want to create a report break that contains the ID, the HCPCS for the high value and the value.

We are using version 4.1 WebI. Can this be done by entering a variable on the Break row? If so, what formula would do this for me?

Thanks.
ELS
Back to top
kbrazell
Principal Member
Principal Member



Joined: 19 Aug 2003

Posts: 207
Location: DFW Metroplex (but mobile) I applied to Mars One


flag
PostPosted: Tue Oct 05, 2021 2:22 am 
Post subject: Re: Return a value based on 2 other values

Hello,

I recommend to post your issue on https://bobj-board.org/ as this current forum is not active anymore.

Thanks !

_________________
Kyle Brazell
General Contractor
BI Developer.....................BOBJ XIr3, on Oracle 8, 8i, 10g, 11g, with HP-UX, AIX, Linux
IoT Developer
Web Developer
Embedded System Programmer
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> About BOB  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

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

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0266 seconds using 18 queries. (SQL 0.0023 Parse 0.0009 Other 0.0234)
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