dave-mills
commented
1 year ago Idea: In addition to converting initiative budgets to the organisation's default currency, we also convert to EUR as a "platform-default" currency. We store that in the projects table, and use that for the budget filtering...
Pros:
- we don't have an overwhelming number of conversions to calculate and store.
- we can correctly filter "yours" and "others" using the same constraints.
Cons:
- we will need to highlight the fact that the budget filters are in EUR and not in the current organisation's preferred currency.
On the main dashboard, the budet filter works with the "budget_org" value for initiatives. This is fine for "your" initiatives, as they will all be in the default currency for the selected organisation. But other organisations' initiatives will have their own default currency. So right now we are comparing different currencies...
The ideal solution is to include the currency for each initiative in all of the default org currencies on the platform. This is quite a challenge, but I'm not sure of another way to be able to effectively group initiatives by 'budget' when every org has potentially a different currency.