Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

*

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

Many Thanks

Kind Regards

Wendy

2 Replies
MVP
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
wendyharrison
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

Community Browser