If no output from Join, count as 0

[emiafshar]

Hi there!

I join a today file and yesterday file to get the following:

1. L output as my closed (if the item is not in today file)

2. J output as my current open

3. R output as my new trades (if not in yday file)

Some days, there aren't any trades in the L output and because i later append the 3 outputs to give me my close, new and open the append then fails as there is no output in L.

How can I get something to come out of my blank output to tell me if it's a 0?

[apathetichell]

Here's a way using datacleanse and with no formula tools...

[HomesickSurfer]

Hi @apathetichell 

I like it as well 🙂

...assuming that only counts are required and without the records' detail

[apathetichell]

Thanks! There's some options with the userids being grouped by as well - but it's not quite as straight forward.