cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to move from signal modeling to system modeling at the first JMP Aerospace Analytics webinar. Register. June 18, 1 p.m. US Eastern Time.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Make Sum quick formula use Sum() function instead of Add()

What inspired this wish list request? 

This post No output result for summation of multiple columns 

 

What is the improvement you would like to see? 

Change quick formula Sum to use Sum() function instead of + as Sum() is able handle missing values. Optionally add other Sum() option which would use Sum (or rather add Add() which would be using Add() or + and Sum should utilize Sum()).

jthi_0-1729188252965.png

https://www.jmp.com/support/help/en/18.0/#page/jmp/statistical-functions-2.shtml?os=win&source=appli...

 

Why is this idea important? 

Gives users option have quickly calculated sum column without always running into issues with missing values.

2 Comments
Status changed to: Acknowledged

Thank you for submitting this request!

jthi
Super User

More or less the same / related but older wish New Formula Column - Sum Function