Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Running total not working correctly Post Reply Post New Topic
<< Prev Page  of 3
Author Message
Nav522
Senior Member
Senior Member


Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Quote Nav522 Replybullet Posted: 31 Oct 2017 at 5:43am
PCTSPLIT is a number, so did something like this
totext(PCTSPLIT) + TRANSID and used it in the evaluate

but i think the issue is deeper here

Based on the PCTSPLIT if its a not 100% then i have to sum up the amount which in below case should be 1500 but with concatenation of TRANSID and PCTSPLIT it is still giving me 750.

NOt sure how to tackle all these conditions

Policy   PCTSPLIT   TRANSID      AMT
JKC69       0        RC        0
             50        DU       750
             50        DU        750
             50        DU        0


IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 31 Oct 2017 at 5:53am
What I would suggest is to try to understand how you would "manually" add these up and how you would know to include and exclude rows based only on what values are available to you. Sometimes there are other fields (primary keys) in your data set that you would never think to display but are the exact value that you would want for the condition. If you can figure out the "data logic", likely someone can assist in converting that logic into a formula.

Edited by DBlank - 31 Oct 2017 at 5:54am
IP IP Logged
<< Prev Page  of 3
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.059 seconds.