turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- ColSum Function results to be placed only once per...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Feb 26, 2015 6:39 AM
(2083 views)

I have a calculation formula in Calculations column as:

Col Sum( :Revenue, :Lable )

The calculation is displayed as calculations, however, is there an oppurtunity to display the result only in the first row of each label (as displayed by the desired column) and the rest rows to be handled as missing data, which helps a lot for further calculations?

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Feb 26, 2015 6:52 AM
(4036 views)

Solution

Try this:

If**(** Row**()** == Col Min**(** Row**()**, :Lable **)**, Col Sum**(** :Revenue, :Lable **)****)**

Or consider using a summary table for further calculations.

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Feb 26, 2015 6:52 AM
(4037 views)

Try this:

If**(** Row**()** == Col Min**(** Row**()**, :Lable **)**, Col Sum**(** :Revenue, :Lable **)****)**

Or consider using a summary table for further calculations.