I have a data form in Hyperion that calculates Qty * Avg Price = Revenue for our departments. Local currency is AUD for this department. The calculation runs correctly for Local currency, but when I switch the data form to USD, everything is calculating correctly for FY12, but on FY13, the Qty number is not crossing over from Local to USD. The Avg Price is converting correctly from AUD to USD, but since there is no Qty number, the Revenue is 0. And it is only for this department, which is a member in shared services.
Any help would be very appreciated.