Forum Discussion
Removing -100% from a calculation
Hi all, I have made a calculation where I want to see the how much the average amount of transport delays per customer correspond with the average amount of transport delays. I am the displaying ...
I solved it now. I created a second measurement that looked at my initial measurement and said "if the first measurement is -100%, then blank, otherwise show first measurement".
IF(measurement1=-1,"",measurement1)
I solved it now. I created a second measurement that looked at my initial measurement and said "if the first measurement is -100%, then blank, otherwise show first measurement".
IF(measurement1=-1,"",measurement1)