2 Replies Latest reply on Mar 23, 2016 10:09 AM by Madhura Selvarajan

    Creating ZN(Lookup( ___ ),0) function calculation based on another calculation.

    Madhura Selvarajan

      Hey, Tableauverse.

       

      I am trying to replace all empty entries with a 0 using the ZN(Lookup) calculation, but am having trouble joining this calculations with another calculation, which I have below.

       

      IF [Dash Board Analysis] ="BEDS (CAMAS)"

      and [Dashboard Category] != 'TOTAL HOSPITAL BEDS (TOTAL DE CAMAS)'

      and [Dashboard Category] != 'TOTAL AMBULATORY BEDS (NUMERO DE CAMAS EN AREA DE AMBULATORIO - "NO CENSABLES")'

      then { INCLUDE [Dashboard Category],[C7 Hospital Name (Nombre Del Establecimiento / De La Sede)]:SUM([Amount])}

      END

       

      Anyone care to chime in?  I'm stumped.