Implementing projects one after the other that realizes energy savings in a section of operations. So if normal energy consumption for the operation is 200 000 GJ as an example. Should project 1 be implemented realizing a 10% saving then the energy after saving would be:
200000 * (1-0.1) = 200 000 * .9 = 180 000 GJ
If we then implement project 2 and it realizes another 10 % saving the saving would be on 180 000 GJ and not 200 000 GJ.
If we, therefore, implement 3 projects then the energy consumption after the 3 projects can be calculated as follows:
Is this the result that you’re looking for? Below is the screenshot provided for the reference -
So at first I considered that in the case of “Gross Consumption” all the projects will consume the same no. of units. And then accordingly as per the conditions that you’ve stated I’ve deducted 10% from every subsequent projects. Below is the formula provided for the reference -
I’m also attaching the working of the PBIX file of the working for the reference. Also providing a link below of the post which was created by one of our expert member @Greg which is based on “How To Fix The Incorrect Totals”.
Hoping you find this useful and meets your requirements that you’re looking for.
Please Note:If this is not the case, then as suggested by @Melissa please provide the working of the PBIX file alongwith the desired results that you’re looking for.
Hi @nico.swartz, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!