# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

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

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(if([Overall Discount %]>0,[Overall Discount %])))

Many Thanks

Kind Regards

Wendy

2 Replies
MVP

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

This expression should produce 0 rather than null values:

RangeSum(Avg([Labour Cost]), Avg([Material Cost]), Avg([Parts Cost]), Avg([Additional Cost]))) *

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
New Contributor II

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

Thanks Jonathan,

That works great thank you.

I can't mark it as correct as my system will not allow me to.

Thanks very much for your help its much appreciated.

Kind Regards

Wendy