806596_en-US

liliconcom

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

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

 

Why is this idea important? 

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

Data Blending and CleanupRe: Make Sum quick formula use Sum() function instead of Add() - Status changed to: Acknowledged

Thank you for submitting this request!

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

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