16 Replies Latest reply: Nov 8, 2016 12:56 AM by Anand Chouhan RSS

    replacing hypen with zero in table

    Supriya R

      Hi,

       

      i have an expression where i am formatting column values in table. Now i need to replace hypen with 0, if value is null

       

      Num(if(Metrics='Invitations',if(Sign($(=Count({$<batch={'23','34'}>}invitation_id))=-1,0,$(=Count({$<batch={'23','34'}>}invitation_id)),

      if(Metrics='Delivered',Alt($=(Sum(delivered)),0),

      if(Metrics='Completions Rate',Sum(completions)/

      Sum(delivered),))), if(Metrics='Completions Rate','#,##0.0%', '#,##0'))

       

      How could i do this?