I have a column of variances, these contain both negative numbers and positive numbers.
I want to gather a sum of all the negative numbers and positive numbers separtely.
Basically saying all the positive overeages = this amount
And all the negative shortages = this amount.
you can see the attached sample.
thanks for any help.
Nick
Bookmarks