// 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;
}
}
}
