ENDIF deactivates formula

[Claire_H_W_UoL]

I wonder if you can help please?

I've got four columns on a report (Tutors 1 and 2 from two different tables) that I need to check if they match. I've written a formula to check if the Tutor 1 fields match and the formula works correctly. However, when I try and create the same formula to check the Tutor 2 fields the formula is set correctly until I enter ENDIF, when it then deactivates the formula and creates a parse error when I run the report: 

I don't know what is causing the formula to be deactivated, as it is recognising the fields I want to reference and the values to show if they match or not, and if I don't put ENDIF I get a "Malinformed if statement" error. I've used the formula function to ensure the gaps and wording is correct so am stumped as to why the formula is deactivated - any help would be gratefully received!

[alexnajm · Accepted solution]

This is likely because the [MAVS Tutor 2] and the [MOD Tutor 2] mismatch in data type (i.e. string vs numeric) - double check both and see if that fixes it!

[Claire_H_W_UoL]

Thanks so much for the quick response - that's exactly what the issue was and it is now working now both data types match!

[alexnajm]

Fantastic! If you could accept it as solution then, that would be great 😊

[Claire_H_W_UoL]

I thought I had sorry! Hopefully it registers as accepted now 😄

[alexnajm]

Yes all done - thank you!