Forum Discussion

RMDNA's avatar
RMDNA
Solution Sage
9 years ago

Infinity, NaN, and divide function

All,   In a custom column, I'm attempting to divide two columns, [Committed] and [Actual] (fixed decimal numbers in the backend, as U.S. Currency), and attempting to get a [% to target] result. The...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi RMDNA,

 

In my opinion, it should be three categories, as both a. and c. have the numerator 0 which can be treated as the same scenario. Based on my tested, use DIVIDE() function, it returns three kind of values, blank, zero and actual decimal.

 

 

If the above is not your required results, please share some sample data and screenshots about desired results for our analysis.

 

Best Regards,
Qiuyun Yu

akaratr's avatar
akaratr
Frequent Visitor
8 years ago

Thanks. I also have the same issue. It's solved.