This content has been marked as final. Show 2 replies
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 %])))