Forum Discussion

swong's avatar
swong
Icon for Helper II rankHelper II
9 years ago
Solved

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.

 

 

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

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

     

     

     

1 Reply

  • pawel1's avatar
    pawel1
    Icon for Kudo Kingpin rankKudo Kingpin

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

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