Unanswered: creating another calculation from a sum calculation
Can the results of a "SUM" calculation be used to perform another calculation in an Access report?
I use the following to determine the % of current paid of the current owed.
=iif(isnull([CURRENT PAID]) or isnull([CURRENT OWED]),null,iif([CURRENT PAID]=0 or [CURRENT OWED] = 0,0,100*[CURRENT PAID]/[CURRENT OWED]))
The current paid and the current owed fields are totaled for each worker.
This is what is used to find the sum of all their cases where there is current paid and current owed.
=Sum([CURRENT PAID]) or =Sum([CURRENT OWED])
Can these formulas for SUM be used to figure the percent of the sum of current paid to the sum of the current owed? Could you give me some idea of how it would look. Thanks