Take a sum of gross amount based on start date and compare with total amount

Help Activities
, ,
1

Hi Devs,

I want to take a sum of weekly amount of similar start date and compare with total amount. if both the amount is same then no need to do anything otherwise need to check the amount in weekly amount column and find which amount we can deduct so that it(Sum of weekly amount) will be equal to total amount.For eg.
The image is a table displaying start and end dates, with corresponding weekly and total gross values for different time periods in 2024. (Captioned by AI)

In the given example if we take a sum of weekly amount(of similar start date) so it is not equals to total amount.in that case we need to delete weekly amount row so that it will equal to total amount.

Thanks,
Riya

2

Hello @Riya1

Filter the Start date with the Unique date value and sum up the values in Weekly Gross and compare it with Total by eliminating one by one column.

3

Hi @Mothilal_Duvvari ,

Can you please share the sample xaml, if possible.

Thanks,
Riya