Swarup, you are GREAT! Your solution is fantastic!
Swarup, your solution is great if the goal is to just have the appearance of a 0 value. This does not solve the issue of performing a calculation on the (now 0) "empty" value.
replacing empty value with 0 works well with the below formula
ZN(LOOKUP((SUM(IFNULL([Number of Records],0))),0))
but when i am trying to filter out some data ,its showing empty not replacing with Zero any soluction
but when i remove the selection another value its showing empty again
i took the twbx from this thread , can you please suggest any solution to zero when appliances selected.