TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Nel
NA
716
1.1m
Formula field returns only 0
Aug 7 2012 2:38 AM
Hi,
I have a Crystal Report which uses data from a Data Table.
I have grouping and calculating sum within the groups. The grouping is by the field vid.
I want to perform calculation where if vid="Pri" the field izn of that row should be summarized, and if vid="Isp" then the field izn should be summarized and then subtracted from the first sum (when vid=Pri).
For the first sum (if vid="Pri") the calculation is ok (for the group with vid="Pri"), but if vid="Isp", (for the group with vid="Isp"), the result of the sum function is always 0, i.e. it doesn't calculate correctly. So I can not perform the last calculation (summarize when vid is Pri and subtract the sum, when vid=Isp).
The first formula which calculates correctly is:
if({DataTable3.vid}="Pri") then Sum ({DataTable3.Iznos}, {DataTable3.vid})
and the formula for the other sum, when vid=Isp is
if({DataTable3.vid}="Isp") then Sum ({DataTable3.Iznos}, {DataTable3.vid})
Can anybody help me please what is the mistake I make in the bold line for having the result 0, instead of the correct result?
Below is the image of the report
Thank you in advance
Reply
Answers (
0
)
Crystal Report generates error
Problem with sumarizing only certain rows in the footer of the crystal report