cancel
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()

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