Group by amout but ignore negatives (1 Viewer)

[Myriad_Rocker]

How would I do this on a report? I want to group by a set of numbers, including negative, but ignore the negative number...

Like this...

123
123
123
-123

46
-46
46

2
2
2

14
-14

etc...

 

[KenHigg]

Try wrapping it in an abs() fuction first - ?

 

[Myriad_Rocker]

Try wrapping it in an abs() fuction first - ?

I actually figured this out right after I asked...

The absolute formula works, too...but here's how I did it...and it maintains the formatting (not that I needed it).

If it was less than 0, multiply by -1. I did this on a column I tagged as a "sort" column. Then, in the report sorting, I sorted on that instead of the original number. This caused it to group all the numbers, regardless of negatives, in the same group. Works...

 

[Myriad_Rocker]

Another question, though...how do I make the report NOT show the row if there's only one to show in that set?

Example: If I have a group of numbers like this:

12
12
12
13
13
14
15
15
15
15

I want to group the numbers like this, but leave out the row where the instance is only one...

12
12
12

13
13

15
15
15
15

 

[Myriad_Rocker]

Another question, though...how do I make the report NOT show the row if there's only one to show in that set?

Example: If I have a group of numbers like this:

12
12
12
13
13
14
15
15
15
15

I want to group the numbers like this, but leave out the row where the instance is only one...

12
12
12

13
13

15
15
15
15

Got this, too. Sorry everyone. I just created a query that counted the numbers and then brought that into my report and excluded all the rows that had a count of less than 2.

Maybe someone with the same question will happen on this and it will help them.

 

[mama_jadaya]

Hello Myriad_Rocker,
can you please tell me how u did this in VBA plzz (a code snippet)

thank you.

I actually figured this out right after I asked...

The absolute formula works, too...but here's how I did it...and it maintains the formatting (not that I needed it).

If it was less than 0, multiply by -1. I did this on a column I tagged as a "sort" column. Then, in the report sorting, I sorted on that instead of the original number. This caused it to group all the numbers, regardless of negatives, in the same group. Works...