How to create a summary field that takes ALL filtering into account for a regular Inquiry screen?

Hi @MichaelShirk 

I’ve created an example of the inquiry screen with some crude DACs. Seems that it matches your description:

Here’s the code behind the example:

using PX.Data;
using PX.Data.BQL;

namespace Sprinterra.CommunityRnd.InquiryTotals
{
    public class MSDetail : IBqlTable
    {
        #region ID
        [PXDBIdentity(IsKey = true)]
        public int? ID { get; set; }
        public abstract class iD : BqlInt.Field<iD> { }
        #endregion

        #region Name
        [PXDBString(30)]
        [PXUIField(DisplayName = "Name")]
        public string Name { get; set; }
        public abstract class name : BqlString.Field<name> { }
        #endregion

        #region Commission
        [PXDBDecimal]
        [PXUIField(DisplayName = "Commission")]
        public decimal? Commission { get; set; }
        public abstract class commission : BqlDecimal.Field<commission> { }
        #endregion

        #region EvenOrOdd
        [PXDBString]
        [PXUIField(DisplayName = "Even or Odd")]
        public string EvenOrOdd { get; set; }
        public abstract class evenOrOdd : BqlString.Field<evenOrOdd> { }
        #endregion
    }
}

using PX.Data;
using PX.Data.BQL;
using System;

namespace Sprinterra.CommunityRnd.InquiryTotals
{
    public class MSFilter : IBqlTable
    {
        #region TotalCommission
        [PXDecimal]
        [PXDefault(TypeCode.Decimal, "0.0")]
        [PXUIField(DisplayName = "Total Commission", Enabled = false)]
        public decimal? TotalCommission { get; set; }
        public abstract class totalCommission : BqlDecimal.Field<totalCommission> { }
        #endregion
    }
}

using PX.Data;
using System.Collections;

namespace Sprinterra.CommunityRnd.InquiryTotals
{
    public class MSInquiry : PXGraph<MSInquiry, MSDetail>
    {
        public PXFilter<MSFilter> Filter;
        protected virtual IEnumerable filter()
        {
            var filter = Filter.Current;
            if (filter == null)
            {
                yield return filter;
                yield break;
            }

            filter.TotalCommission = 0;
            var startRow = 0;
            var totalRows = 0;

            foreach (MSDetail row in Records.View.Select(new[] { filter }, null, null, null, null, Records.View.GetExternalFilters(), ref startRow, 0, ref totalRows))
            {
                filter.TotalCommission += row.Commission;
            }

            yield return filter;
        }


        public PXSelect<MSDetail> Records;
    }
}

<%@ Page Language="C#" MasterPageFile="~/MasterPages/FormDetail.master" AutoEventWireup="true"
    ValidateRequest="false" CodeFile="MS123456.aspx.cs" Inherits="Page_MS123456" Title="Test Inquiry" %>

<%@ MasterType VirtualPath="~/MasterPages/FormDetail.master" %>
<asp:Content ID="cont1" ContentPlaceHolderID="phDS" runat="Server">
    <px:PXDataSource ID="ds" Width="100%" runat="server" Visible="True" PrimaryView="Filter" TypeName="Sprinterra.CommunityRnd.InquiryTotals.MSInquiry" >
         <CallbackCommands>
        </CallbackCommands>
    </px:PXDataSource>
</asp:Content>
<asp:Content ID="cont2" ContentPlaceHolderID="phF" runat="Server">
    <px:PXFormView ID="form" runat="server" DataSourceID="ds" Style="z-index: 100" Width="100%" DataMember="Filter">
        <Template>
            <px:PXNumberEdit ID="edTotalCommission" runat="server" DataField="TotalCommission" />
        </Template>
        <AutoSize Container="Window" Enabled="True"/>
    </px:PXFormView>
</asp:Content>
<asp:Content ID="cont3" ContentPlaceHolderID="phG" runat="Server">
    <px:PXGrid ID="grid" runat="server" DataSourceID="ds" Width="100%" Height="150px" SkinID="PrimaryInquire" AdjustPageSize="Auto" >        
        <CallbackCommands>
            <Refresh RepaintControlsIDs="form" />
        </CallbackCommands>
        <Levels>
            <px:PXGridLevel DataMember="Records">
                <Columns>
                    <px:PXGridColumn DataField="Name" TextAlign="Left" Width="100" />
                    <px:PXGridColumn DataField="Commission" TextAlign="Left" Width="100" />
                    <px:PXGridColumn DataField="EvenOrOdd" TextAlign="Left" Width="100" />
                </Columns>
            </px:PXGridLevel>
        </Levels>
        <AutoSize Container="Window" Enabled="True" MinHeight="400" />
        <AutoCallBack Command="Refresh" Target="gridOption" ActiveBehavior="true">
            <Behavior RepaintControlsIDs="form" />
        </AutoCallBack>
    </px:PXGrid>
</asp:Content>

As it was made quickly just for proof-of-concept purposes, it lacks more controls expected for inquiry screen, but should be enough to get things going.  

Let me know if I’m missing something and this is not the result you’re expecting.