Re: [MS_AccessPros] Report subtotals and totals

 

To head off a possible question: the records for this report are from a
query - the underlying tables do NOT have redundant entries for NPAmt
and PerAmt.
Sigurd

On 2017-07-12 14:45, sigurd@solbakkn.com [MS_Access_Professionals]
wrote:
> I have a report for which I want to calculate some totals, and don't
> know how to put together the proper equations to do that.
> The individual records include fields GID, Cat, and Actual.
> The report is grouped on GID (Grant ID) and Cat (Category). I have the
>
> report calculating the sum for Actual in the footer for Category.
> There
> are two categories, N (Non-Personnel) and P (Personnel). Each category
>
> has a maximum billable, NPAmt and PerAmt, respectively. (Each grant
> has
> a single value for each maximum; those values are repeated in every
> record, hence available for use in calculations.
>
> In the footer for the category, I show, in addition to Sum(Actual),
> the
> appropriate maximum, and then the lower of the two figures as the
> amount
> actually billed for that category.
>
> I would like to have an accurate grand total billed for each grant,
> but
> need to compare the individual subtotals against the appropriate max,
> rather than comparing Sum(Amount) for the whole grant agains the sum
> of
> the category maximums. The calculation would be on the order of:
> Min(Sum(Amount) for category N,NPAmt) + Min (Sum(Amount for category
> P,
> PerAmt).
>
> Any help on the syntax for this calculation would be greatly
> appreciated.
> Sigurd Andersen
>
>
>
> Links:
> ------
> [1]
> https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/messages/116451;_ylc=X3oDMTJyYnZxYWo4BF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzExNjQ1MQRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE0OTk4OTQwNjE-?act=reply&messageNum=116451
> [2]
> https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/newtopic;_ylc=X3oDMTJlcnF1ZWllBF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTQ5OTg5NDA2MQ--
> [3]
> https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/topics/116451;_ylc=X3oDMTM4MWxkY2Y0BF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBG1zZ0lkAzExNjQ1MQRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzE0OTk4OTQwNjEEdHBjSWQDMTE2NDUx
> [4] https://yho.com/1wwmgg
> [5]
> https://groups.yahoo.com/neo/groups/MS_Access_Professionals/info;_ylc=X3oDMTJlN3Y2anAxBF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTQ5OTg5NDA2MQ--
> [6]
> https://groups.yahoo.com/neo/groups/MS_Access_Professionals/members/all;_ylc=X3oDMTJmODJqb2RoBF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzE0OTk4OTQwNjE-
> [7]
> https://groups.yahoo.com/neo;_ylc=X3oDMTJkcWptYnVzBF9TAzk3MzU5NzE0BGdycElkAzY0NDg5NzgEZ3Jwc3BJZAMxNzA1MTE1MzcwBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNDk5ODk0MDYx
> [8] https://info.yahoo.com/privacy/us/yahoo/groups/details.html
> [9] https://info.yahoo.com/legal/us/yahoo/utos/terms/

__._,_.___

---

Posted by: sigurd@solbakkn.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___