Print Page | Close Window

Formula field question

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9678
Printed Date: 04 May 2024 at 6:11am


Topic: Formula field question
Posted By: ace213
Subject: Formula field question
Date Posted: 13 Apr 2010 at 11:43am
Hello,
 
I've designed a report which contains ITEM, MNTHLY_PMNT, and ORIG_AMT fields. Each ITEM has multiple rows for MNTHLY_PMNT and ORIG_AMT.
 
I'm trying to add a formula field ( REM_BAL) that will output the following.
- for the first row of each new ITEM, subtract MNTHLY_AMT from ORIG_AMT
- for following rows for the same ITEM, subtract current row's MNTHLY_AMT from the previous row's REM_BAL.
 
I have created a global function and tried applying my limited knowledge to figure out some logic, but that didnt get me anywhere. I'd appreciate it if someone could guide me through this.
 
Thanks


Replies:
Posted By: kevlray
Date Posted: 13 Apr 2010 at 11:58am
Have you tried having a running total for {MNTHLY_AMT} and substract that from {ORIG_AMT}.  It appears that this report would be grouped by {ITEM}, thus your running total would be reset by that group.
 
I hope this helps.


Print Page | Close Window