-
15. Re: Substituting 0 when we 'Show Empty Rows' option ?
Still no luck. See the screenshot of my calc and how it looks when I pull it in. The weird thing is the calc says computed across table but when I pull it in, it computes down. I don't have an option for across when I pull it in.
-
16. Re: Substituting 0 when we 'Show Empty Rows' option ?
Swarup, you are GREAT! Your solution is fantastic!
-
17. Re: Substituting 0 when we 'Show Empty Rows' option ?
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.
-
18. Re: Substituting 0 when we 'Show Empty Rows' option ?
Hi Swarup,
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.
