Hi Guys.
I have a CUSTOMERS table and a REPORTS table.
REPORTS references CUSTOMERS so I can see all the related reports per customer in the customer view.
Now I want to create a virtual column in my CUSTOMERS table which reflects the latest [Date] field between all the REPORTS entries for that Customer.
I suspect you first need use an expression to find the array of REPORTs that have the specific CUSTOMER as a field and then plug another expression in that extracts the latest date from that array.
Iโve been trying these kinds of expressions for some time but have basically resolved to leaving it to the experts. Please give a man some help.
Regards
Gerhard
Solved! Go to Solution.
Please try
MAX(SELECT([Related Reports][Date], [Report Type] = โScheduled Maintenance Reportโ))
Please try the following expression in the VC
MAX([Related Reports][Date])
This is perfect, Suvrutt.
Many thanks.
I realised there is another layer that could be of great help. In the REPORTS table is a field called [Report Type]. If I wanted to do the MAX() together with an IF() that only considers the dates where the [Report Type] = โScheduled Maintenance Reportโ, how would I go about that?
Regards
Gerhard
Please try
MAX(SELECT([Related Reports][Date], [Report Type] = โScheduled Maintenance Reportโ))
Thanks a mil Suvrutt.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |