Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try to use if date greater particular date use new expression else use old expression