Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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)
Thank you very much,
Solved my problem