- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculating progress self reliancy with changing division and amount of children
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try to use if date greater particular date use new expression else use old expression