topic Re: JMP Formulas: Selecting Multiple Variables that are not Next to Each Other in Discussions

JMP Formulas: Selecting Multiple Variables that are not Next to Each Other

mcstagger — Fri, 21 Aug 2015 12:13:07 GMT

I am trying to sum several variables together that are spread out across my data file. How do I select all of these variables without having to manually type them into the formula?

Re: JMP Formulas: Selecting Multiple Variables that are not Next to Each Other

KarenC — Fri, 21 Aug 2015 14:05:17 GMT

So, I learned a new trick this week while reading the new JMP book Building Better Models with JMP Pro which makes adding formula columns so so easy. If you right click on a column heading in your table there is a menu item "New Formula Column" and you can add a column with a formula based on the column you are selecting from with a single click. I just tried this with multiple selected columns (not all together) in a data table, right click on one of them and select then NewFormulaColumn>Aggregate>Sum and you are done with the exception of perhaps renaming the column.

Re: JMP Formulas: Selecting Multiple Variables that are not Next to Each Other

mcstagger — Fri, 21 Aug 2015 14:59:10 GMT

That works! Thank you!

EDIT: Why are my posts being moderated?

Re: JMP Formulas: Selecting Multiple Variables that are not Next to Each Other

jenkins_macedo — Fri, 21 Aug 2015 15:16:06 GMT

This answer has already been answered, but the table > summary platform could be used to do that by assigning the sum under the statistics drop down menus and adding those to the statistics window and the category or sub-categories that you want each of the variables in the statistics windows to be grouped or sub-grouped by can go into the respect folders. In this example, Program Line is equal to the following: Intl, Dom, AF)

Data Table( "CRSVersion30-Enrollments-August-6th461838" ) <<

Summary(

Group( :Mail Code ),

Sum( :Name( "# Confirmed Enrollments" ) ),

Sum( :Name( "# First Time Enrollments" ) ),

Sum( :Name( "$ Confirmed Enrollments" ) ),

Sum( :Name( "$ Program Only" ) ),

Sum( :Name( "$ Total Enrollment Amt" ) ),

Sum( :Name( "$ Total Net Order" ) ),

Subgroup( :Program Line ),

Freq( "None" ),

Weight( "None" )

)

This script derived from running the procedure described above would generate a new table with the summary data table order in the form where:

Mail Code N Rows =Sum(# Confirmed Enrollments, Intl) Sum( # First Time Enrollments, Intl) Sum($ Confirmed Enrollments, Intl) Sum($ Program Only, Intl) Sum($ Total Enrollment Amt, Intl), Sum($ Total Net Order, Intl) Sum(# Confirmed Enrollments, Dom) Sum( # First Time Enrollments, Dom) Sum($ Confirmed Enrollments, Dom) Sum($ Program Only, Dom) Sum($ Total Enrollment Amt, Dom), Sum($ Total Net Order, Dom) Sum(# Confirmed Enrollments, AF) Sum( # First Time Enrollments, AF) Sum($ Confirmed Enrollments, AF) Sum($ Program Only, AF) Sum($ Total Enrollment Amt, AF), Sum($ Total Net Order, AF).

You could also use Transpose under table

Re: JMP Formulas: Selecting Multiple Variables that are not Next to Each Other

jenkins_macedo — Fri, 21 Aug 2015 15:29:31 GMT

This is a public forum for JMP users and the post are moderate to make sure that information are credible, good for this forum scholarly platform, etc.

Re: JMP Formulas: Selecting Multiple Variables that are not Next to Each Other

mcstagger — Fri, 21 Aug 2015 15:51:08 GMT

Ah, gotcha! Thought I may have offended someone with my elementary JMP questions.

Have a great weekend!

Re: JMP Formulas: Selecting Multiple Variables that are not Next to Each Other

Jeff_Perkinson — Fri, 21 Aug 2015 16:18:37 GMT

We are currently having a problem with spam posts in the JMP User Community, so all content is being moderated. We're working on updating the spam tools. With luck we'll be able to back off the moderation levels shortly.

BTW: Even my post is being moderated.

Jeff Perkinson

JMP Community Adminstrator

Re: JMP Formulas: Selecting Multiple Variables that are not Next to Each Other

jenkins_macedo — Fri, 21 Aug 2015 16:20:09 GMT

Not really. It is good sharing ideas especially dealing with a software that provides so much potential on how I now see data analysis, visualization and predictive analytics. If you could, the San Diego Summit in a couple of weeks would be a great platform to each key individuals and other users. Have a wonderful weekend yourself.

Best