Grouping problem 1

[Tamina]

I would like to group my records like this:

Field1
Group0 empty or equal to '#00000000'
Group1 value1
Group2 value2
...
GroupN valueN

So, I want different groups for different values, except for empty and null value of Field1 - which I want to put together in 1 group. How do I do that, is it possible?

 

[Naith]

Create a formula:

If IsNull({Field}) or {Field} = '#00000000'
Then 'Others'
Else {GroupingField}

and group on that.

Alternatively, if you have a reasonable finite number of possible groupings, you can use a specified group.

All the best,

Naith

 

[synapsevampire]

If I understand correctly, try creating a formula based on the value field akin to:

@MyGroupFormula
If isnull({MyTable.MyValue}) or {MyTable.MyValue} = 0
then
0
else
{MyTable.MyValue})

You can now insert this group of zero and nulls combined, or it will contain the individual values.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

Naith's is more accurate, use that.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com