Hello

To eradicate duplication in a report that is leading to a sum being incorrect I was going to create a formula to divide the sum by the number of records. In principle this works fine but when creating the formula I am facing a problem. I have inserted the summary to the group FNO_SEQ4 but when I select the sum in the formula editor

Sum ({SRS_FNP.FNP_AMNT}, {SRS_FNO.FNO_SEQ4})

I get a message saying there must be a group that matches this field. I know the group exists as I have just created it and can see it in the report, any ideas? I'm not sure if it is something to do with the table rather than what I am trying to achieve as when originally entering the group the value kept displaying as zero despite browse data showing the correct value. I removed the group and re-added it and the values appeared correctly. Has anyone seen anything like this before? I feel like I am going mad!!

Thanks
Esther