Conditional Counting of Portal Rows

[therron36]

Hi,

I have a portal which tracks client sessions by date. The portal is within a client details layout. One of the field on this layout is "health plan date" (a date field).

What I would like to do is have a calc field which displays the number of sessions a client has had since the health plan date.

Another words how many portal rows display sessions dated at or later than the date displayed in the "health plan date" field

Can this be done with the count function?

Thanks

[therron36]

O.K. - figured it out via a relationship.

Still would like to know if there is a way of doing this with a calc field.

[comment]

With two calc fields:

One in the Sessions table (result is Number) =

SessionDate ≥ Clients::health plan date

The other in the Clients table, using Sum ( Sessions::calcField )

Or you could write a custom function to recurse over the child records, using the GetNthRecord() function.

[therron36]

Comment - Thanks for taking the time to answer my question.

Seems obvious with hindsight :