Solved: Divide values in one column by values in another c...

swong · ‎08-23-2017

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.

pawel1 · ‎08-23-2017

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

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

pawel1 · ‎08-23-2017

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

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

Divide values in one column by values in another column