Reports including values that should be excluded

Lesley De Vries

Hi there,

I am building a report and when I indicate I want the "What" to include all values below 100%, the report still includes the 100% tasks as well.

I have tried to entered the in between 1-99 and 0-99 values too buit it still spits out a report including 100% martked takss.

I feel a bit puzzled by this. Can anyone tell me what I can do so 100% tasks are excluded from the report?

 

Many thanks!

Benjamin Walker

Lesley,

 

100% = 1 if the cell is formatted with a percent sign.

Try between 0 and .99!

 

 

Ben

Lesley De Vries

Thanks Ben, it works!

 

Cheers,

Lesley