Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression in a table that calculates the number of enrolments when a user selects a year. I would like to add a column to the table that calculates the number of enrolments for the previous year. I am having difficulty doing this and wonder if it is because my Year field is presented in the following format e.g. 2015-16 to represent an academic year.
Thanks for any help.
Greg
Hi Greg,
Maybe you will shared a small fragment of the original data and the expected result?
Regards,
Andrey
How about this?
Count({<Year = {'$(=Max(Year)-1)'}>} enrollment)
I know you have format like 2015-16. You can play with some Date format
try this
with same format you are calculation current year
Count({<Year = {'$(=only(Year)-1)'}>} enrollment)
other then that i think you have to make an other table
like
2015-16 July 1 2015 Jun 30 2016
2016-17 July 1 2016 Jun 30 2017
and use intervalmatch to like with you Master Calendar