Discussion board where members can get started with Qlik Sense.
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(if([Overall Discount %]>0,[Overall Discount %])))
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)
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.