topic Get unique values in App Development

Get unique values

Afernandes — Sat, 16 Nov 2024 20:33:39 GMT

Good morning everyone, I know that there are similar topics, but in no way did I find a solution to this question, which although it seems simple is giving me problems.

Summing up. I have two tables. In a table has C_ID (referring to the courses that a university has). In the other table there is the Anolectiv (referring to the period in question 2016/2017, 2017/2018 ... etc) what I wanted to count the number of new courses. That is to say only in the courses that are only associated with the last period. I have experimented with several formulas of set analysis. But I can never get only the new courses.

Can anyone give me an idea?

Thank you very much,

Re: Get unique values

jonathandienst — Fri, 28 Jun 2019 09:40:23 GMT

Assuming the periods are string values, then something like:

Count({<Period = {'$(=MaxString(Period))'}> - <Period -= {'$(=MaxString(Period))'}>} Distinct C_ID)

Its a little simpler if the periods are numerics or duals. To prevent this responding to selections, just add a 1<...> to the two qualifier clauses:

Count({1<Period = {'$(=MaxString(Period))'}> - 1<Period -= {'$(=MaxString(Period))'}>} Distinct C_ID)

Re: Get unique values

Afernandes — Fri, 28 Jun 2019 10:30:52 GMT

Thank you very much,

Solved my problem