Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
Regular business hours will resume on Monday, October 5, 2026.

Discussions

Solve problems, and share tips and tricks with other JMP users.

Choose Language Hide Translation Bar

Level III

Apr 27, 2025 06:35 AM (4771 views)

For each ID group in the data table, I like to calculate:

The count of Part Number where RANK_DESC = 1
The count of Part Number where RANK_ASC = 1

I like to add two new columns PN Count of RANK_DEC =1, PN Count of RANK_ASC=1. any formulas to apply for them?
any other better methods to approach? thanks very much in advanced!

10 REPLIES 10

Level XIII

Apr 28, 2025 01:12 PM (618 views) | Posted in reply to message from ReliabilityWolf 04-28-2025

welcome.