MROUND - Rounding to the nearest 5
Good afternoon, Having an issue with MROUND. I have a table with college courses, and would like to look at the FTE for each institution and course, how ever it doesn't seem to like "the value for FTE cannot be determined. Either the column doesn't exist, or there is not current row for this column" So table would look something like this Year Institution Qual FTE Gender 2019/20 1 Dip 1 1 2020/21 3 Cert 0.5 2 2019/20 1 First 1 2 2020/21 3 Cert 1 1 2019/20 1 First 1 1 The measure was FTE Rounded = MROUND([FTE]),5) So the output would look like Year FTE FTE Rounded 2019/20 3 5 2020/21 1.5 0 (as less than 2.5, rounds down) Any help greatly recieved.