u/JJ4prez

Matrix visual:

Entity	Value1	Value2	MetricColumnCalc
A	598	1513.8836	0.16
B	256	679	0.32

Value 1 and 2 are in my source data, and are simple sums when placing in matrix. Value 1 / Value 2 needs to be the MetricColumnCalc answer, but I am getting weird results. I am using the divide function for this. When I do Value1/Value2 - I get NaN as Value 1 and Value 2 can be zeros. I switched to Divide (value1/value2,0) but I am afraid that 0 is creating more 0s to calculate, creating a lower than intended score. Maybe I need to keep my blanks as blanks and not 0?

For example, 598/1513.8836=0.395 (not 0.16). Value 1 and 2 are both constant, in every row. Granted this is summarized, and I tried sumx/divide/etc., but it seems like such a simple calculation but is creating headaches.