Banding financial values

[#1]

Hello everyone,

I've been working within an application to try and group some of our monthly financial values into bandings. The issue I'm having is our data for leavers is in minus figures and the script I've got seems to ignore any values that are minuses.

Does anyone know how I can do this? I want to be able to put the value -7500 in the band 5-10k.

I can't change the minus to a positive as we have balancing data that ends up double counting

Any ideas is appreciated.

[Roop]

It would be useful if you include the script.

You could just process the 2 differently with and IF... statement...

Pseudo code:

If(DateLeaving > DateEmployed,

     Band5to10,

     Band the data as normal .....

) as Banding,

[rubenmarin]

Hi Samuel, how you assigning bandings?

Maybe using fabs() when asigning the value to the banding can help. fabs() returns the absolute number, so it's always positive.