MuhammadZiaUrRehman
New Member
- Joined
- May 14, 2016
- Messages
- 9
Hey guys so the problem that i am trying to solve is that if the Exchange Diff amount in Total Column is less than or equal to any of the Receipts Value, then, in the value column, the date for that receipt must then show.
If some how the Exchange Diff amount is more than any of the receipts amount, then the first dates of Total whose sum make more than or equal to the Exchange Diff amount must be shown in the value column bifurcating total amount into new rows for that total amount of that Exchange diff.
If this can be done in Power Query in Excel or by any other formula, it will be really helpful to me.
If some how the Exchange Diff amount is more than any of the receipts amount, then the first dates of Total whose sum make more than or equal to the Exchange Diff amount must be shown in the value column bifurcating total amount into new rows for that total amount of that Exchange diff.
If this can be done in Power Query in Excel or by any other formula, it will be really helpful to me.
Description | Receipt Date | Total | Document Number | Value |
Bill | 100,000 | 4000 | ||
Receipt | 02.01.2019 | -10,000 | 4000 | |
receipt | 02.03.2019 | -20,000 | 4000 | |
Receipt | 15.03.2020 | -50,000 | 4000 | |
Exchange Diff | -20,000 | 4000 | ||
Bill | 200,000 | 4001 | ||
Receipt | 01.04.2020 | -30,000 | 4001 | |
Receipt | 10.04.2020 | -50,000 | 4001 | |
Receipt | 20.04.2020 | -30,000 | 4001 | |
Receipt | 25.04.2020 | -20,000 | 4001 | |
Exchange Diff | -70,000 | 4001 |