Hello

Please help as I think I'm going mad!!

I am trying to create a formula that divides a sum by the distinct count of records. I have created a group that is {SRS_FNO.FNO_SEQ4} and in my formula I am writing Sum ({SRS_FNP.FNP_AMNT}, {SRS_FNO.FNO_SEQ4}). when I put this it says there must be a group that matches this field despite the fact I can see it in the report and am selecting it from the field selector. Any ideas?

Also when adding the group initially the group header value was displaying as zero for all groups despite the browse data function showing the correct data, after removing and re-adding the group the correct value showed. Is this a problem with the data tables rather than my formula?

Thanks
Esther