INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# YTD formula in Crystal Report

## YTD formula in Crystal Report

(OP)
Hi all,

I am creating a report with Crystal Reports V.11 but I am stuck with the YTD. Anyone can help me how do I have the dynamic YTD on my the report by monthly?

Here is the scenario:
In the database, there are couple fields that I am using on the report. They are:
1. {Year}
2. {period}
3. {Debit}
4. {Credit}

Here are the data from database:
Year Period Debit Credit
2015 01 $100$500
2015 02 $150$400
2015 03 $200$700

To get the profit, I have a formula for called profit = round({credit}-{debit})
So based on above data, my profit in
2015 01 is $400 2015 02 is$250
2015 03 is $500 What I am trying to achieve is, if I run this report on January I should have this layout with correct YTD amount: Year Period Profit 2015 01$400

and if I run the report next month, which is February, I should have this layout with correct YTD amount:
Year Period Profit
2015 02 $650 and...if I run the report on March, I should have this layout with correct YTD amount: Year Period Profit 2015 03$1150

so, let' say if I want to re-run the report of February in May, I should get the layout and correct YTD amount like this:
Year Period Profit
2015 02 \$650

Anyone can help me to do this YTD? Thank you all

### RE: YTD formula in Crystal Report

PARMS
YTD ==== SELECT NUMBER
YEAR ==== SELECT DATE
PERIOD === SELECT NUMBER

SELECT
ypdc.Year
,ypdc.Period
,P.Debit
,P.Credit

FROM
YPDC ypdc
Profit p
LEFT OUTER JOIN on ypdc.YEAR = P.YEAR
LEFT OUTER JOIN on ypdc.PERIOD = P.PERIOD
WHERE
IF YTD NOT EQUAL 1 THEN
YEAR = P.YEAR AND AND P.PERIOD = PERIOD
ELSE
YEAR NOT EQUAL P.YEAR AND P.PERIOD NOT EQUEAL PERIOD

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!