Sum of Price Columns in UX List

[Evan Perry]

I'm trying to calculate the total of all the prices in a list. After calculating the total, it would either be input into a Detail View for List 3 (Hierarchy mentioned below) to be edited or pushed to the server. The list contains 2 different prices based on the type of sale. The list is populated through SQL and is built in disconnected mode with the data being Pre-loaded. The List is a great-grandchild in the list (List1 -> List2 -> List3 -> Target List). I have tried to use the "Compute Summary Values" in the list, but the "afterClientSideSummaryCompute" event triggers before the list is populated.
Can someone help to lead me to a possible Solution or provide an example?
I'm currently on a trial version of Alpha Anywhere which is using Version 12.4.2, Build 3670_4684.
- Evan

[Davidk]

Re: Sum of Price Columns in UX List

Evan... first... thanks for providing needed information... excellent.

I understand the principle of what you'd like to do but need a bit of clarification. You're only wanting to calculate totals for List 4. Is that right? You say List 4 contains 2 different prices... but does that mean 2 different columns to total and add together... or 1 column to sum?

[Evan Perry]

Re: Sum of Price Columns in UX List

I have 2 different columns which need to be summed together, e.g. SUM(column1) + SUM(column2). The last 2 columns in the attached image contain the customer's sale and refill amounts and I want to sum both columns and get the total amount spent by that customer to store in a field called orderAmount. Each row contains a different item that they have ordered or refilled.
orderAmount = SUM(NewSaleAmount) + SUM(NewRefillAmount)

Column_Description.jpg

[Davidk]

Re: Sum of Price Columns in UX List

Since you're pre-loading data... all the child data is actually in it's Parent List. It's not an issue to get the data Array and sum 2 properties in the Object per row. Pushing it out to the Detail View of the Parent seems to be a bit messy. I'm going to continue to have a look at that, because it's really interesting.

However, using the Child List we can get this done. The List afterClientSideSummaryCompute is interesting... but... it fires twice for anything it does. Not sure why, but I'll try to find out. Also, it's timing isn't the best for what we want. Instead, use the Child List onList Draw event...

var totSale = {dialog.object}.getListClientSideSummaryValue('LISTCHILD','NEWSALEAMOUNT','total');
var totRefill = {dialog.object}.getListClientSideSummaryValue('LISTCHILD','NEWREFILLAMOUNT','total');
var sumTot = totSale + totRefill;
sumTot = Math.round(sumTot*100)/100;
{dialog.Object}.setValue('CUSTAMOUNT',sumTot);

This gets the Summary Values, totals them, and shoves the total into the Parent Detail View.

Then, in the Parent List, onClick event...

setTimeout(function(){
var lObj = {dialog.object}.getControl('LISTPARENT');
lObj.updateListFromUXControls();
},200);

Here, we just save the .setValue() result to the Parent List. But, we have to give our Lists a bit of time to settle down before doing this. If you don't... really really horrible things happen. Nothing damaging or permanent... just horrible. Try it without the setTimeout and let me know if you can see the odd results.