{"action":"created","issue":{"url":"https://api.github.com/repos/humanitarianresponse/site/issues/146","labels_url":"https://api.github.com/repos/humanitarianresponse/site/issues/146/labels{/name}","comments_url":"https://api.github.com/repos/humanitarianresponse/site/issues/146/comments","events_url":"https://api.github.com/repos/humanitarianresponse/site/issues/146/events","html_url":"https://github.com/humanitarianresponse/site/issues/146","id":112351884,"number":146,"title":"FTS Graph with negative figures","user":{"login":"javedyousafzai","id":3966785,"avatar_url":"https://avatars.githubusercontent.com/u/3966785?v=3","gravatar_id":"","url":"https://api.github.com/users/javedyousafzai","html_url":"https://github.com/javedyousafzai","followers_url":"https://api.github.com/users/javedyousafzai/followers","following_url":"https://api.github.com/users/javedyousafzai/following{/other_user}","gists_url":"https://api.github.com/users/javedyousafzai/gists{/gist_id}","starred_url":"https://api.github.com/users/javedyousafzai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/javedyousafzai/subscriptions","organizations_url":"https://api.github.com/users/javedyousafzai/orgs","repos_url":"https://api.github.com/users/javedyousafzai/repos","events_url":"https://api.github.com/users/javedyousafzai/events{/privacy}","received_events_url":"https://api.github.com/users/javedyousafzai/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/humanitarianresponse/site/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"MartinMaritim","id":3490890,"avatar_url":"https://avatars.githubusercontent.com/u/3490890?v=3","gravatar_id":"","url":"https://api.github.com/users/MartinMaritim","html_url":"https://github.com/MartinMaritim","followers_url":"https://api.github.com/users/MartinMaritim/followers","following_url":"https://api.github.com/users/MartinMaritim/following{/other_user}","gists_url":"https://api.github.com/users/MartinMaritim/gists{/gist_id}","starred_url":"https://api.github.com/users/MartinMaritim/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MartinMaritim/subscriptions","organizations_url":"https://api.github.com/users/MartinMaritim/orgs","repos_url":"https://api.github.com/users/MartinMaritim/repos","events_url":"https://api.github.com/users/MartinMaritim/events{/privacy}","received_events_url":"https://api.github.com/users/MartinMaritim/received_events","type":"User","site_admin":false},"milestone":null,"comments":5,"created_at":"2015-10-20T11:59:56Z","updated_at":"2015-11-02T09:53:29Z","closed_at":null,"body":"Yemen office reprots that their 'Funding by Donor Contribution' is showing negative figures; \r\nAfter asking Sean Foo and Maiju Kaarin, the following reply was sent;\r\n**Reply from Maiju**\r\nYes indeed in our current system we have negative values, as Sean pointed out we have to use them whenever there is re-allocation of funds within the plans/appeals. Otherwise we would be double counting the funding.\r\n\r\nThe negative figures you see are all allocations from three different sources which we treat as pooled funds in the system.\r\n\r\n1) ERF \r\nAs FTS is at the moment only able to capture the 1st level of funding, it counts the funding going in to the country-based pooled funds. When these funds get distributed to the agencies in-country, we cannot make a record of it without adding the negative balancing entry. Otherwise we would be double-counting the same funds twice.\r\n\r\n2-3) WFP and UNICEF contribution treated as pooled funds\r\nWe also treat in a similar manner in many countries WFP and UNICEF funding due to the nature of their reporting. They report us regularly/monthly basis the contributions they receive from different donors to a specific country. However, they are not able to tell us as frequently the full allocations of these funds to specific projects requirements in the HRP. Therefore we record the contributions to WFP/UNICEF to a 'pooled fund'. When these agencies quarterly basis report FTS the breakdown of the contributions against different projects/sectors, the funds get distributed from WFP/UNICEF 'pooled fund' to their respective projects.\r\n\r\nWhat it comes to the bar chart 'Funding by Donor Contribution' in your website, our recommendation is that you exclude the ERF as a donor, as the funds going into ERF are already recorded under the ERF donor countries.  For the negative values of WFP and UNICEF, you can just ignore them. This way you would get more realistic picture of the funding by donor.\r\n** - - - - - - - - - - - - - - - - - - - - - - - - - - - - **\r\n\r\nI have asked Martin to look at the FTS module and do the necessary changs to hide the negative numbers and show only those which are explained by Maiju.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/humanitarianresponse/site/issues/comments/152973883","html_url":"https://github.com/humanitarianresponse/site/issues/146#issuecomment-152973883","issue_url":"https://api.github.com/repos/humanitarianresponse/site/issues/146","id":152973883,"user":{"login":"MartinMaritim","id":3490890,"avatar_url":"https://avatars.githubusercontent.com/u/3490890?v=3","gravatar_id":"","url":"https://api.github.com/users/MartinMaritim","html_url":"https://github.com/MartinMaritim","followers_url":"https://api.github.com/users/MartinMaritim/followers","following_url":"https://api.github.com/users/MartinMaritim/following{/other_user}","gists_url":"https://api.github.com/users/MartinMaritim/gists{/gist_id}","starred_url":"https://api.github.com/users/MartinMaritim/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MartinMaritim/subscriptions","organizations_url":"https://api.github.com/users/MartinMaritim/orgs","repos_url":"https://api.github.com/users/MartinMaritim/repos","events_url":"https://api.github.com/users/MartinMaritim/events{/privacy}","received_events_url":"https://api.github.com/users/MartinMaritim/received_events","type":"User","site_admin":false},"created_at":"2015-11-02T09:53:29Z","updated_at":"2015-11-02T09:53:29Z","body":"We need to ask if negative values should be included at all ..."}}