i also want to make a sum in the end of each
i have column that have amount.
One of many approaches is to group the data by the first column value
(Non-LINQ, LINQ Approach)
your file works. but when i applied it in my workflow it shows this warning. i don’t know.
it works now . not my problem is in the same column i have cell that contains (-) i can’t convert the column price because of if . can you help?
Can you share any screenshot?
Price total will be 109
Working fine for me.
Can you explain your issue little elaborate.
when this activity is enabled
uipath throws this error
Assign: Input string was not in a correct format.
Input string was not in a correct format.
Hi @ldiaz ,
Could you show us the data containing that specific value which contains hyphen (-) ?
It might also be the case if there are empty values in the column. Do you have such values ?
In that case, Could you check with the below Expression :
FilteredDT.AsEnumerable.Sum(Function(x)CDbl(if(x("Column Name").ToString.IsNumeric,x("Column Name").ToString,"0")))
Can you try this
hi . this works . thank you
Can you mark as Solution
Can you check this xmal
SortData1.xaml (4.7 KB)
Hi @ldiaz ,
Apology for asking you have marked solution to your reply !
Could you mark solution to my post!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.