Hi,

I have a report which calculates a percentage based on a jobs planned time by actual time (0.80.0.81 = 0.99%) the percentage sign is irrelevant as that's added in after the calculation.

What I would then like to do is suppress values between -9.9 & 9.9, however select expert doesn't like it and still shows all of the data.

Is there away to exclude these lines?

Thanks

Sorry - the formula should be 0.80/0.81 = 0.99

Here's the actual formula:

If {wip.wruntim} > Average ({@actual_per_min}, {used.uopnum}) Then (
    //Planned > Actual, so divide by actual to get correct percentage difference
    If Average ({@actual_per_min}, {used.uopnum}) = 0 Then
        0 //Prevent div by 0 error
    Else
        //Average Difference Percentage = (AverageActual-Planned)*100 / Planned
    ((Average ({@actual_per_min}, {used.uopnum}) - {wip.wruntim}) * 100) /Average ({@actual_per_min}, {used.uopnum})
)
Else (
    //Planned < Actual, so divide by planned to get correct percentage difference
    If {wip.wruntim} = 0 Then
        0 //Prevent div by 0 error
    Else
        //Average Difference Percentage = (AverageActual-Planned)*100 / Planned
    ((Average ({@actual_per_min}, {used.uopnum}) - {wip.wruntim}) * 100) /{wip.wruntim}

It's just working out the average total on that one line

Thanks