Counting missing links (or "failed relationships" ?)

[Bobbby]

Hi,

I'd just like to check with you that what I'm doing is OK.

I'm trying to count

"joins / relationships / links"

that don't happen.

Example products that haven't sold =

no product ID in the sales table.

I've pasted an explanation pic here at

It's pretty straightforward.

My way of counting the "missing links" seems to be too good to be true.

Is it ?

TIA

Bobbby

[comment]

The basic calculation is this:

Count ( sales::product id )

This returns the number of times a product has been sold. Everything else can be derived from that, except 'No Sale Count' which is a concept that I don't get (you want to count the number of times something has NOT happened?).

The If() construct is not required, because aggregating over a relationship automatically takes into account only related records.

[Bobbby]

I have to find out which Products don't appear in Sales.

The No Sale Count is to flag the Products that have not (yet) sold.

That's the one I have to get right.

Here's an example of a product with no sale.

The No Sale field lights up as "1".

Thanks for the info on the "If".

Bobbby

[comment]

The products that don't appear in Sales are those for which the above calculation returns zero (or empty - depending on whether the calculation is defined to 'evaluate if all referenced fields are empty'). I believe this one field can be used for ALL your needs - see attached.

CountSales.fp7.zip

[Bobbby]

OK.

Thanks.

Even simpler than I thought.

And the Yes /No tip is pretty cool too.

I'll try that Monday.

Bobbby