CODEWITHSUNDEEP
filemaker
Jerome
Jerome

Reputation: 6189

Filemaker summaries on related fields and calculations

Attempting to create a calculation field for a sub-summary sorted on a related field

GetSummary ( sumValue ; client::grouping )

returns empty result. Ordering and Summaries are being generated, but not the calculation.

I've attempted to create in the exiting table both a text field => lookup for client::grouping and a calculation field = client::grouping as a sorting field and adjusting the breakField under getSummary, but am getting the same blank.

Any thoughts on how this can be achieved?

Upvotes: 0

Views: 735

Answers (1)

michael.hor257k
michael.hor257k

Reputation: 116982

The breakfield in GetSummary() must be a local field. A calculation field = client::grouping should serve well - but you also must sort by the same calculation field (and not by the related client::grouping field).

Upvotes: 2

Related Questions