Forum Discussion
swong
Helper II
9 years agoDivide 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
Kudo Kingpin
DIVIDE formula should make it. simply add New Column (Modeling ribbon) and type the formula:
New Column = DIVIDE(Table1[Numerator],Table1[Denominator])