Joined: 09 Mar 2012
Online Status: Offline
Posts: 46
Topic: Comparing a Group Sum to A Maximum Field Posted: 31 Oct 2014 at 2:26pm
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum