It works fine for me as well for single date. If i take entire data,it won't show any data.
Hi we can't see your data but could you have null values in the data set if so then wrap your numerator and denominator in ZN function
Hi, the data looks pretty similar to the one i have provided as sample. Due to some concerns i cant upload the data.
By the way i tried your suggestion but still same issue. I am wondering how come it shows the data for single date but if i pull entire data and do the calculation, it is showing as null.