show Latest NOT-NULL Value if last day's value was null
Dears
I have a table that sometimes some value get NULL , because the related table does not load completely.
because of that I want to show, If data was not loaded and was NULL, it should not show the zero value for it, and should the last item that had value.
sum(if("the value was null,show the latest value that is not Null", "else show the current value"),totaldownload)
