re-post : a question about percentages and money

  • Thread starter Thread starter scubadiver
  • Start date Start date
S

scubadiver

Hello,

This wasn't answered the first time.

A record can belong to one of three groups and each group has a total
monetary value attached to it.

How can I calculate the total for each group as a percentage of the overall
total?

like

1 £33 33%
2 £33 33%
3 £33 33%
 
hi,
How can I calculate the total for each group as a percentage of the overall
total?
1 £33 33%
2 £33 33%
3 £33 33%
Click to expand...

SELECT
ID,
Amount,
Amount / DSum("Amount","yourTable") AS Percentage
FROM yourTable




mfG
--> stefan <--
 
hi,

The DSum() must be modified a little bit:

Amount / DSum("Amount","yourTable", "ID=" & [ID]) AS Percentage


mfG
--> stefan <--
 
Back
Top