Calculate all invoice amounts on a particular day/ss

Help Studio
, , ,
1

Hello Uipath Community,
I need help in solving. I am stuck with this exercise. Thank you

INPUT: Excel sheet1

Date | Amount

1-1-2020 | 100 <—Same date
1-1-2020 | 200 <—1-1-2020
2-2-2020 | 300
2-3-2020 | 400 <—Same
2-3-2020 | 400 <—Date
2-3-2020 | 400 <—2-3-2020

OUTPUT: Excel sheet2

Date | Amount

1-1-2020 | 300 <----Total the amount if same date 1-1-2020
2-2-2020 | 300
2-3-2020 | 1200 <----Total the amount if same date 2-3-2020

2

Hi,

Can you try the following?

img20210610-5

Sample20210610-3.zip (8.6 KB)

Regards,

2 Likes
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.