Dear all,
For our charity foundation, the most important KPI is self reliance. We have been calculating this till now with the below-mentioned formula in the app overview itself.
((Sum({<Category={'Project'}>} Amount) + Sum({<Category={'Community'}>} Amount))/ Count (distinct (Month)))
/ (Sum({<Class={'Primary'}>} "Costs Min")* Sum({<Class={'Primary'}>} "Division")
+ Sum({<Class={'High School'}>} "Costs Min")* Sum({<Class={'High School'}>} "Division")
+ Sum({<Class={'Preschool'}>} "Costs Min")* Sum({<Class={'Preschool'}>} "Division"))
However, now the amount of children (values of the 'Division' column) have changed. I can of course later the numbers, but would lose the historical progress. Therefore, I would like to know what you guys advice would be the best and most elegant approach to this.
Looking forward to your reactions.
