Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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