Conditional table

[#1]

Hello

I have been looking for a while and I can't find my answer.

I got 2 table one containing some event and in the other one the history of the event.

What I want to work with is a table that would contain, depending on the type of the event, different calculations.

That would be the table I want to obtain in the end.

	criteria	Indicator 1	Indicator 2	Indicator 3
Event1	Criteria 1	Is calculated	Is calculated (according to his history)	Is not caculated
Event2	Criteria 1	Is calculated	Is calculated (according to his history)	Is not caculated
Event3	Criteria 3	Is not caculated	Is calculated	Is calculated (according to his history)
Event4	Criteria 2	Is not caculated	Is calculated (according to his history)	Is calculated

I hope I was clear enough. If not I will try to clarify my question.

[#2 · Accepted solution]

Something like:

Indicators:
load

Event, (<your formula1>) as Indicator 1
where EventType = '1'
resident HistoryTable;

join load
Event,, (<your formula2>) as Indicator 2
where EventType = '2' or EventType = '3'
resident HistoryTable;

join load
Event, (<your formula3>) as Indicator 3
where EventType = '2' or EventType = '3' or EventType = '5'
resident HistoryTable;

You need to have the Event Type as a field in the event-table.

[#3]

I had to modify it a little but it works.

Thx a lot