cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
fionaweston
Level III

how do I use a formula that subtracts Col B from Col A and divides by Col C but on a per month basis

I have 3 months of data in my file, Jan, Feb and Mar.

I'm using this formula 

(Col Sum( :A ) - Col Sum( :B )) / Col Sum( :C )

But I need the value per month.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: how do I use a formula that subtracts Col B from Col A and divides by Col C but on a per month basis

Most Col Stat() functions support optional by-variables. 

 

This formula, where :Month is the by-variable, give monthly values (repeated in every row of each month)

(Col Sum( :A, :Month ) - Col Sum( :B, :Month )) / Col Sum( :C, :Month )

 

 

View solution in original post

2 REPLIES 2
ms
Super User (Alumni) ms
Super User (Alumni)

Re: how do I use a formula that subtracts Col B from Col A and divides by Col C but on a per month basis

Most Col Stat() functions support optional by-variables. 

 

This formula, where :Month is the by-variable, give monthly values (repeated in every row of each month)

(Col Sum( :A, :Month ) - Col Sum( :B, :Month )) / Col Sum( :C, :Month )

 

 

fionaweston
Level III

Re: how do I use a formula that subtracts Col B from Col A and divides by Col C but on a per month basis

Perfect, thanks!