Dividing percentages evenly 1

[gaperry]

Hi all,

I have a number that I need to divide accross a group of percentages.

Example: $1000 - Need to spread this number accross the following percentages 60%,30% & 10% to find the correct $$$ value for each.

Note that the total percentage will always be %100. There are several fields that could contain a percentage number but the percentage overall will always total %100 which means some fields will be null values or contain no percentage to calculate against.


Any help here is appreciated,

Thanks.

 

[PaulBricker]

SELECT tblValuesAcrossFields.EntryID, tblValuesAcrossFields.Amt, tblValuesAcrossFields.Pct1, tblValuesAcrossFields.Pct2, tblValuesAcrossFields.Pct3, tblValuesAcrossFields.Pct4, [Amt]*([Pct1]/100) AS Expr1, [Amt]*([Pct2]/100) AS Expr2, [Amt]*([Pct3]/100) AS Expr3, [Amt]*([Pct4]/100) AS Expr4
FROM tblValuesAcrossFields;

My data looked like this.

EntryID  Amt  Pct1   Pct2   Pct3   Pct4
A   1500   35   35   0   30
B   2000   22   35   10   33
C   1000   60   30   0   10

The answers came out correctly.  I only used whole numbers so I didn't test for percentages like  25.75%


Paul

 

[gaperry]

PaulBricker,

thanks ! exactly what I was looking for.