cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
0 Kudos

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

Status: New Submitted by Super User yesterday
Comment

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.