Displaying the first instance from two different tables

[Sahubba]

I am having issues trying to display the first time of an event.
I have to tables where I need to look for that data in.

Table 1 Events Table 2 History of events.

There maybe times where a customer has more than one event and if that happens the data goes into Table 2. So I need the first recorded time of that event and it may come for either tables.
Can someone please help me if this is possible to do. Thanks

 

[lbass]

Assuming you have a group on customer, you could display the first event date, by using this formula:

minimum([minimum({Events.Date},{table.customer}),minimum({HistoryofEvents.Date},{table.customer})])

-LB