Is there a way to restrict the return value from a specific table?

[#1]

Hi all,

I'm trying to identify the MIN and MAX dates for a table of sales data I have, the issue I have here is that this table is linked to a larger date calendar which enables me to link in other table data sets, which means that the MIN and MAX are bringing back the date range from ALL available dates, rather than just from the table in question.

Is there a way to restrict my selection to just the table of data I am interested in obtaining the min and max dates for?

Thanks,

RG

[#2 · Accepted solution]

You could use à set analysis in your min/max. Using à field in the table you want to analyse that you know is populated. Max({<KeyField={"*"}>}Date)