case when "DocDate"<=CAST(ADD_DAYS(CURRENT_DATE,-1) as date) then sum("TransValue") else 0
I need a hardcoded date instead of (CURRENT_DATE) so that my user can able to fetch the report on all days with actual result for that particular date.
Thanks Kumar
1.4m articles
1.4m replys
5 comments
56.9k users