make output of counting functions be treated as float type instead of integers.
Currently, using aggregate functions such as Count will return an integer, meaning if you attempt to calculate something of the form of ColuntnonBlank/Count, you will get 0 since both are integers. This seems like an unnecessary limitation. I was able to bypass by multiplying by both number by 1.0, but this seems cumbersome and should not be required to perform such a calculation.
1
vote
Jonathan Loranger
shared this idea