2 Replies Latest reply on Dec 7, 2018 11:23 AM by sindhu gullapalli

    Replace the empty value with 0,i have tried with ZN and lookup funtion but purpose is not resolving

    sindhu gullapalli

      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.

       

      Thanks in Advacne!!