How To Perform Arithmetic Operation in LWC Lightning Data Table In Salesforce

Let's assume we are getting a response from apex class for a cancelled ticket with details like total amount paid and refunded amount after cancellation.

If i would like to perform/display  the cancellation charges on screen with help of deducting the Total Refunded Amount from the Total Paid amount .In this article we will see how can we perform this in simple steps while using the LWC data table.

import { LightningElement, api, track, wire } from "lwc";
import fetchActivities from "@salesforce/apex/CancelFlowCntrl.fetchCanActivities";

const columns = [
    { label: 'ticketvalue', fieldName: 'totalTicketvalue' },
    { label: 'refundedAmount', fieldName: 'totalRefundedAmount' },
    { label: 'cancellationCharges', fieldName: 'totCancellationCharges' },
    
];

export default class ActivitiesFlow extends LightningElement 
{
  
  @track allActivitiesData;
  
  @wire(fetchActivities, { recdId: '$sfrecordId' })
    wiredActivities({ error, data }) {
       if (data) 
       {
          this.allActivitiesData =  data.map( record => Object.assign(
		{ "totalTicketvalue": record.apiResptotalTicketvalue, 
		  "totalRefundedAmount": record.apiResptotalRefundedAmount,
		  "totCancellationCharges": record.apiResptotalTicketvalue-record.apiResptotalRefundedAmount
		 },record
		)
            );
		}
		
		else if (error) {
            this.error = error;
            this.allActivitiesData = undefined;
           
        }
	}
 }

Please comment or write us if you have any queries/requirements.

Please like,follow,bookmark,subscribe this site to receive daily updates.

LinkedIn Group -  Srinivas4sfdc (I Love Coding... You?)

FaceBook Page - I Love Coding. You?

Hope this helps you..Enjoy..!