I need to create new indicators based on sets of two previously existing indicators. I have a list of the new ones that need to be created, and the indicators that are needed to create them, but I can't figure out how to do it.
The data is set up like this, and there are around 100 countries and around 50 indicators to be created. So for example, I need to create an indicator with an Indicator.ID of 126.96.36.199 whose Indicator.Value is the Indicator.Value of Indicator.ID 3.2.1 minus the Indicator.Value of Indicator.ID 3.2.2. So these would be new rows in the data (one per new indicator per country), not new columns.