Got a query for your mighty brains, if you can help me out with this, that would be quite several awesomes.

 

I need to be able to build a report for management that basically counts the number of events that are attended, and also split by event type as well. 

We have two tables, Events, and Eventtypes.

 

Events can be as little as the following for this example:

 

ID, ClientSerial, Date, Attended

 

Each event is linked to a set of Eventtypes, being the actual components recorded by workers for the event they're recording.  Looks kinda like this:

 

EventTypeID, EventID, Eventtype

 

That making sense?  This would probably best be described by example.

 

 

 

What I would like to do, is create a formula with a name EventHasTriage, that would do the following:

For each Event.EventID, looking at the related Eventtype.EventID, that if any Eventtype.Eventtype = 'Triage' then EventHasTriage = 'Triage', else EventHasTriage = 'Other'

 

 

Is there help to be had? 

 

 

I'm half way through what you've suggested, and am already getting a 0 or 1 that's correct, so I can work from there if I need to.

 

Before I even entered your final equation into the formula workshop, I was wondering about the " you have in that line.  Sure enough, when I tried to check it, gave an error.  I went with the following line:

 

if SUM(0">{@has_triage},{Events.EventID})>0 then 'Triage' else 'Other'

 

It worked fine then.

 

So, thank you muchly!  I didn't expect to get this one done this evening.  Sacrifice of the small furry animal of your choice now available upon reply.

 

Cheers.

it should just be

 

Maybe a jackalope?