Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello all,
I'm having some trouble to calculate/generate a new monthly table with the right diminishing values. Here below example data containing 1 object. The value of object 1 is predefined on specific dates one year ahead of the previous predefined value. So in this example object 1 is worth 52.000 on july 2020 and 41.000 on july 2021.
I want to create a new table that calculates the table on a monthly basis. Between july 2020 and july 2021 the depreciation is 916,67 per month ((52k-41k) /12, but i'm having an issue with generating a new table because in the period of july 2021 and july 2022 the depreciation is not the same -> (41k-28k)/12 = 1083,33. Objects data are always predefined on specific dates in the future and i'm not sure how to get the right calculation for that. I'm hoping someone can help me out with this.
Kind Regards, Muffin
Solved! Go to Solution.
@Muffin92 , Based on what I got. You can add end date column and then follow the approach in attached file
or refer blog for measure approach
@Muffin92 , Based on what I got. You can add end date column and then follow the approach in attached file
or refer blog for measure approach
Thank you alot for these tips and tricks. This gives me alot of perspective! It will help me solve my issue.
Kind Regards Muffin