By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,155 Members | 2,518 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,155 IT Pros & Developers. It's quick & easy.

Dividing Two Running Sums on a Report

P: n/a
Greetings all!

I have a report in which I have seven columns:

Column 1: Day number (i.e. Day 1, Day 2, Day 3, etc.).
Column 2: SalesCost for that day.
Column 3: SalesCost to-date (running sum of SalesCost)
Column 4: SalesRevenue for that day.
Column 5: SalesRevenue to-date (running sum of SalesRevenue)
Column 6: CostRatio for that day.
Column 7: CostRatio to-date (value from Column 3 divided by value from
Column 5)

The problem is with Column 7 - I cannot seem to be able to divide the
two numbers and give the result as a percentage. Here is some sample
data to help illustrate what I am trying to achieve - it is the last
column I cannot get to work - RatioTo-Date:

DAY N. CostToday CostTo-Date RevenueToday RevenueTo-
Date RatioToday RatioTo-Date
1 10 10
100 100 10%
10%
2 20 30
50 150 40%
20%
3 15 45
20 170 75%
26,47%

Thank you!

Aug 12 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Odeh Naber wrote:
>I have a report in which I have seven columns:

Column 1: Day number (i.e. Day 1, Day 2, Day 3, etc.).
Column 2: SalesCost for that day.
Column 3: SalesCost to-date (running sum of SalesCost)
Column 4: SalesRevenue for that day.
Column 5: SalesRevenue to-date (running sum of SalesRevenue)
Column 6: CostRatio for that day.
Column 7: CostRatio to-date (value from Column 3 divided by value from
Column 5)

The problem is with Column 7 - I cannot seem to be able to divide the
two numbers and give the result as a percentage. Here is some sample
data to help illustrate what I am trying to achieve - it is the last
column I cannot get to work - RatioTo-Date:

DAY N. CostToday CostTo-Date RevenueToday RevenueTo-
Date RatioToday RatioTo-Date
1 10 10
100 100 10%
10%
2 20 30
50 150 40%
20%
3 15 45
20 170 75%
26,47%

Try setting the Ratio to Date text box's Format property to
Percent or 0.0%

--
Marsh
MVP [MS Access]
Aug 12 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.