Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all
Would like to know if anybody could give some tips/solutions on how could I solve this challenge:
I need to split between start date and end date , by month / trimester / semester or annual, depending on the payment type, the commission amount.
Payment type | Dt.Start | Dt.End | Commision |
Month | 22/04/2019 | 06/10/2021 | € 317,06 |
Trimester | 02/10/2019 | 06/10/2021 | € 339,52 |
Semester | 31/07/2018 | 06/10/2021 | € 293,27 |
Month | 29/05/2018 | 06/10/2021 | € 388,12 |
Month | 20/06/2018 | 06/10/2021 | € 821,50 |
Semester | 01/09/2018 | 06/10/2021 | € 214,65 |
Semester | 01/08/2018 | 06/10/2021 | € 101,78 |
Month | 01/07/2018 | 06/10/2021 | € 634,45 |
Month | 01/01/2021 | 06/10/2021 | € 166,41 |
Annual | 14/09/2020 | 06/10/2021 | € 118,31 |
Month | 15/11/2019 | 06/10/2021 | € 428,81 |
Trimester | 29/06/2018 | 06/10/2021 | € 63,10 |
Month | 20/11/2019 | 06/10/2021 | € 79,27 |
Month | 21/10/2020 | 06/10/2021 | € 465,84 |
Month | 29/10/2018 | 06/10/2021 | € 372,74 |
Annual | 24/06/2019 | 06/10/2021 | € 901,28 |
Month | 16/08/2019 | 06/10/2021 | € 111,95 |
Month | 19/01/2021 | 06/10/2021 | € 275,91 |
Month | 02/07/2019 | 06/10/2021 | € 390,22 |
Month | 27/12/2019 | 06/10/2021 | € 155,16 |
Trimester | 01/12/2020 | 06/10/2021 | € 80,94 |
Month | 01/12/2019 | 06/10/2021 | € 48,03 |
Month | 24/11/2020 | 06/10/2021 | € 199,00 |
Really appreciate your inputs
KR
Paulo
Hello jppv20,
thanks for your reply
I get the payment of this commissions per payment type also , so I would like to create a control to validate what I',m getting as payment is correct .
Taking as example the first entry :
Payment type | Dt.Start | Dt.End | Commission |
Month | 22/04/2019 | 06/10/2021 | € 317,06 |
The Output will be something like :
Split the 317,06 by the difference between dates(year/month)
Accrual on year/month the commision
After I will be able to check , per year /month, in this case, what they payed is the same I have accrual.
hope this help.
KR
Paulo
Hi @pmargarido ,
Can you provide a screenshot of the desired output? This will help understand better what you are trying to achieve.
Hello jppv20,
Will be somehting like this.
This figure shows the amount acumulated on the Start date ... and I need splited from start date until end date that is always = todays date.
thks
Paulo
Hi @pmargarido ,
I read it carefully, but I don't understand what you want to split? Under what conditions?
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello V-lianl-msft
thks for your reply
I want to split the commission amount per payment type , month, trimester, etc , from strat date to end date .
hope this calrify
Payment type | Dt.Start | Dt.End | Commision |
Month | 22/04/2019 | 06/10/2021 | € 317,06 |
Trimester | 02/10/2019 | 06/10/2021 | € 339,52 |
Semester | 31/07/2018 | 06/10/2021 | € 293,27 |
Month | 29/05/2018 | 06/10/2021 | € 388,12 |
Month | 20/06/2018 | 06/10/2021 | € 821,50 |
KR
Paulo
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |