I've got a report that has a variable of depots and lists the variance. We have a depot that has a repair centre and as such both these are shown on the same report. I need it for each item number to suppress the item if the variance for the depots mirrors each other.

 

I've looked at using abs(variance) but this will exclude items if both are up the same quantity so they have to be the opposites of each other.

 

Help is much appreciated

 

Spotafly