Redacté el siguiente código para obtener una cantidad total, pero devuelve un error.
Code
TotalCharges__c = [SELECT sum(EntryCharge__c) FROM AllocationTable__c WHERE id=:id];
TotalCharges__c: currency
EntryCharge__c: expression (currency)
Error
Error al guardar: Asignación no permitida desde LIST<AggregateResult> a Decimal CalculateCharge.trigger
Para utilizar una función de agregación, utilice el tipo AggregateResult. Además, es necesario utilizar el método valueof para cada tipo para convertir el tipo, porque los datos de resultado de la agregación no pueden almacenarse en una variable Decimal directamente.
Para ver detalles específicos, consulte el ejemplo a continuación:
*******************************
AggregateResult ar = [SELECT sum(EntryCharge__c) s FROM AllocationTable__c WHERE id=:id];
TotalCharges__c = decimal.Valueof(string.valueof(ar.get('s')));
system.debug('data = '+String.valueof(j.TotalCharges__c));
*******************************
Para la conversión del tipo String, consulte este tema.
000385401

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.