Posted: 1 Nov 2018 18:48 EDT Last activity: 5 Nov 2018 5:13 EST
How to sum a pagelist in datatransform
HI, I am the below to sum up the ProductCost property returned from a datapage list. I am getting incorrect results when more than one row is returned. It seems like it is summing up the the second result twice. i.e. if the first row's product cost is 50 and the second one is 30 then I get a total cost of 60.00.
set .TotalCost = @sum(D_ProductList.pxResults().ProductCost)
I have attached the pxResults from the clipboard.
Can you please advise how to get the correct sum results.
***Edited by Moderator: Pallavi to update platform capability tags***