I have a report where I have one field in the detail record in which I sum in the Group Footer field. I have another field in the detail record that I am inserting a summary but using the maximum option.

I want to compare these two numeric records in the group footer by using a formula where if the numbers do not equal I return a message of some sort indicating they are not equal but my "if then else" statement doesn't work. Maybe I am missing something obvious?

Is there a formula anyone can suggest where I compare these two values and if they aren't equal return a message in the formula indicating as such.

Thanks in advance for any suggestions.