2 Replies Latest reply: Aug 7, 2017 8:34 AM by Wendy Harrison RSS

    How do I make a blank cell come back to zero in my formula

    Wendy Harrison

      Good Afternoon everyone,


      I am creating a formula in Qlik Sense which works perfectly apart from the values which should be 0.00 are showing as -.


      This is having a knock on effect with other parts of my table.


      Does anyone know how I can get my results to change to 0.00 so that this is recognised throughout my table.


      Below is the formula which I am using.


      (Avg([Labour Cost])

      +Avg([Material Cost])

      +Avg([Parts Cost])

      +Avg([Additional Cost]))


      (Avg(if([Overall Discount %]>0,[Overall Discount %])))


      Many Thanks

      Kind Regards