If in Aggr funcation

[#1]

Hi all

Im facing the following problem. really appricate your help.

lets say I have the following table:

Activity   ID	Type ID	Type
1	12	A
1	13	A
2	14	B
3	15	A
4	16	B
5	17	A
5	18	A

I want for each activity ID that its type is only "A" Ill display the biggest value.

the request table i would like to show is:

how can I use the aggr funcaiton?

thanks!

[Anonymous]

Hello,

PFA

HTH

[agomes1971]

Hi,

please see attached.

HTH

André Gomes

[Clever_Anjos · Accepted solution]

Use Set Analysis

[#5]

Thank you all so much you really helped me!!

maybe you could help me to achieve also the following.

lets say I have additional coulmn to the original table:

Activity id	Type Id	Type	error activities
1	12	A	10
1	13	A	15
2	14	B	10
3	15	A	20
4	16	B	30
5	17	A	40
5	18	A	40

I want to display only the error activities of the biggest Type id so the table will be like the following:

Activity id	count of minimal error
1	15
3	20
5	40

is that possible?

thanks!