Forum Discussion

Helper 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.

pawel1
9 years ago
DIVIDE formula should make it. simply add New Column (Modeling ribbon) and type the formula:
New Column = DIVIDE(Table1[Numerator],Table1[Denominator])

Kudo Kingpin

9 years ago

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

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