Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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([Additional Cost]))

*

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

Many Thanks

Kind Regards

Wendy

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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
Anonymous
Not applicable
Author

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