Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need your support in Beginning balance and Ending balance calculations!
I have stucked with interest payment because there is first payment indicated as amount.
How can I put such calculation in Beginning and Ending formula?
There is my calculations but it is wrong in such scenario.
Ending Balance = if([Beginning Balance] - ([Payment] - ([Beginning Balance] * sum('Līgumi'[Rate in period]))) >= 0, [Beginning Balance] - ([Payment] - ([Beginning Balance] * sum('Līgumi'[Rate in period]))),0 )
I allready calculate interest with FIRST payment, but I dont know how correctly to put it in Beginning and Ending calculations.
Thank you in advance,
GINMED
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |