Jump to content

Using Functions in Subsummaries

This topic is 7159 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies


I have a database of patient surveys that I have upgraded from FM 6 to FM 7, and am having trouble producing accurate reports using subsummaries.

Normally, calculations work fine with subsummaries--if, for example, C = A + B, then I could write the following formula:

C = GetSummary(A, break field) + GetSummary(B, break field)

HOWEVER, if a calculation contains a formula, then FM 7 will show an average of ALL surveys (i.e. not doing a subsummary)

For example, the following formula would work in FM 6, but NOT FM 7 (as far as I can tell)B)

C = Average(GetSummary(A, break field), GetSummary(B, breakfield).

Similar results occur with other functions, such as Count().

Is there any way I can find subsummaries of fields based on calculations containing functions in FM 7?

Any information you might have would be MOST appreciated!!

Link to comment
Share on other sites

I was able to reproduce this behavior. The GetSummary() part is working correctly, but the Average() is not. To get it to work, you could change the calculation to:

C = (GetSummary(A, break field) + GetSummary(B, break field)) / 2


GetSumA = GetSummary(A, break field)

GetSumB = GetSummary(B, break field)

C = Average(GetSumA; GetSumB)

Link to comment
Share on other sites

This topic is 7159 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.