Save field calculated using business logic to database

 @Dmitrii Naumov Thank you for your detailed reply. I have implemented a couple of the calculations in the DAC, but I have noticed very strange behavior across different GIs.

In this test GI I created, many of the values that should be 0.00 show up as blank.

When I tried to add to the Customers GI, I get even weirder behavior. The YTD Invoice Total shows as blank for all customers. If I filter by customers who have a YTD Invoice Total not equal to 0, it correctly filters the customers, but the column showing the value is still blank for those customers.

Here is the code I have used. Is this calculation too complex and why we are having the issues or do you think there something else going on?

using System;
using PX.Data;

namespace PX.Objects.AR
{
    public sealed class CustomerExt : PXCacheExtension<Customer>
    {
        [PXDecimal]
        [PXUIField(DisplayName = "YTD Invoiced Amount")]
        [PXDBScalar(typeof(Search4<ARInvoice.goodsTotal, Where<ARInvoice.customerID, Equal<Customer.bAccountID>, And<ARInvoice.docType, Equal<ARDocType.invoice>, And<DatePart<DatePart.year, ARInvoice.docDate>, Equal<DatePart<DatePart.year, Today>>>>>, Aggregate<Sum<ARInvoice.goodsTotal>>>))]
        public decimal? UsrYTDInvTotal { get; set; }

        [PXDecimal]
        [PXUIField(DisplayName = "Total Invoiced Amount")]
        [PXDBScalar(typeof(Search4<ARInvoice.goodsTotal, Where<ARInvoice.customerID, Equal<Customer.bAccountID>, And<ARInvoice.docType, Equal<ARDocType.invoice>>>, Aggregate<Sum<ARInvoice.goodsTotal>>>))]
        public decimal? UsrInvTotal { get; set; }

        public abstract class usrYTDInvTotal : IBqlField, IBqlOperand
        {
        }

        public abstract class usrInvTotal : IBqlField, IBqlOperand
        {
        }
    }
}