Hi, 

In my application I upload an Excel file with account numbers and a date. I'm monitoring this account in a table. I created a join by the account number. This table compares the Current date with the previous date to see if any information of the account has changed. My problem is that went the account is NEW it doesn't appear in the table because I am comparing the current date with the previous date. I want to create a Count in another page that shows in an Expression how many NEW accounts are added in a day by using an Aggregate. 


Thanks.

Hi! 

In the aggregate join you have to use "With or without " option and in the filters select the lines with the Id from the old accounts table equal to "nullidentifier(). 

The result should show only the new ones. 

Hope this help

Graça 

Solution

Hi again !

It would be something like :

 

Solution