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

      Wendy