// calculate ratio for Markham/Michigan/Texas public void CalculateRatio(ExcoCategory salesCategory) { foreach (ExcoAccount account in groupAccountMap.Values) { for (int i = 0; i < 12; i++) { account.actualRatio[i] = (account.actual[i] / salesCategory.ActualThisYear[i]) * -1.0; account.budgetRatio[i] = (account.budget[i] / salesCategory.BudgetThisYear[i]) * -1.0; } } }
// calculate ratio for Colombia public void CalculateRatioColombia(ExcoCategory salesCategory) { foreach (ExcoAccount account in groupAccountMap.Values) { for (int i = 0; i < 12; i++) { account.actualRatio04[i] = (account.actual04[i] / salesCategory.ActualThisYear[i]) * -1.0; account.budgetRatio04[i] = (account.budget04[i] / salesCategory.BudgetThisYear[i]) * -1.0; account.actualRatio41[i] = (account.actual41[i] / salesCategory.ActualThisYear[i]) * -1.0; account.budgetRatio41[i] = (account.budget41[i] / salesCategory.BudgetThisYear[i]) * -1.0; account.actualRatio48[i] = (account.actual48[i] / salesCategory.ActualThisYear[i]) * -1.0; account.budgetRatio48[i] = (account.budget48[i] / salesCategory.BudgetThisYear[i]) * -1.0; account.actualRatio49[i] = (account.actual49[i] / salesCategory.ActualThisYear[i]) * -1.0; account.budgetRatio49[i] = (account.budget49[i] / salesCategory.BudgetThisYear[i]) * -1.0; } } }