cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
swong Regular Visitor
Regular Visitor

Divide values in one column by values in another column

Hi,

 

How can I create a new column by dividing values in one column by another column? I need to account for zero values in the denominator.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
pawel1 Member
Member

Re: Divide values in one column by values in another column

DIVIDE formula should make it.  simply add New Column (Modeling ribbon) and type the formula:

New Column = DIVIDE(Table1[Numerator],Table1[Denominator])

 

 

 

1 REPLY 1
pawel1 Member
Member

Re: Divide values in one column by values in another column

DIVIDE formula should make it.  simply add New Column (Modeling ribbon) and type the formula:

New Column = DIVIDE(Table1[Numerator],Table1[Denominator])