
1. Re: Calculate difference between the measure in max year and the year before
Deepak Rai Jun 20, 2018 9:46 AM (in response to Diogo Braga)1 of 1 people found this helpfulTry:
{FIXED School Code, Year:SUM(if {MAX(Year)}=Year Then School Grade end)}{FIXED School Code, Year:SUM(if {MAX(Year)}1=Year Then School Grade end)}
Or This:
SUM({FIXED School Code, Year:SUM(if {MAX(Year)}=Year Then School Grade end)})SUM({FIXED School Code, Year:SUM(if {MAX(Year)}1=Year Then School Grade end)})

2. Re: Calculate difference between the measure in max year and the year before
Hari Ankem Jun 20, 2018 9:47 AM (in response to Diogo Braga)See if this helps:
IF [Year]={FIXED [School Code]: MAX([Year])} THEN [School Grade (Numerical)] ELSE 0 END

IF [Year]={FIXED [School Code]: MAX([Year])}1 THEN [School Grade (Numerical)] ELSE 0 END

4. Re: Calculate difference between the measure in max year and the year before
Deepak Rai Jun 20, 2018 10:12 AM (in response to Diogo Braga)Your Year is a String?
Then use
INT({MAX(year)})

5. Re: Calculate difference between the measure in max year and the year before
Deepak Rai Jun 20, 2018 10:14 AM (in response to Diogo Braga)Now you also Put INT in front of Year. so use
INT({MAX(year)})=INT(Year)
INT({MAX(year)})1=INT(Year)

6. Re: Calculate difference between the measure in max year and the year before
Diogo Braga Jun 20, 2018 10:15 AM (in response to Deepak Rai)I changed year to INT and the 1st option return blank, and the second option returned the correct answer. I wonder why. Thank you for your help.

7. Re: Calculate difference between the measure in max year and the year before
Deepak Rai Jun 20, 2018 10:16 AM (in response to Diogo Braga)1 of 1 people found this helpfulI Know Why, Because we needed to Subtract Aggregations, It Works That way Only.