Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Conditional Running Totals Post Reply Post New Topic
Author Message
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Topic: Conditional Running Totals
    Posted: 31 Jan 2013 at 7:30am

Hello guys,

I need to create a running total for my report that need grand total but when I tried to created a grand totals the amount would double or triple given me incorrect values. These are my formulas that being use in my report the get the value that I need. I need make a running total or grand total. Any helps and tips would be lovely.
 
IF {V_BI_AP_AGING.DUE_DATE}in Aged61To90Days THEN {V_BI_AP_AGING.AMT}
 
if {V_BI_AP_AGING.DUE_DATE}> date(year(today()),month(today()),day(today())) then {V_BI_AP_AGING.AMT}
 
Thank you in advance!!!
Smile
IP IP Logged
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Posted: 31 Jan 2013 at 8:55am

I mean I need a grand total for this formula not running total

if {V_BI_AP_AGING.DUE_DATE}> date(year(today()),month(today()),day(today())) then {V_BI_AP_AGING.AMT}
 
Please help!!
IP IP Logged
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Posted: 01 Feb 2013 at 3:04am
I just realize that my question might not make sense. So I am going to try agian. I am using all of my dat from Pervasive SQL 2011.1 and all of my information coming from String. So basicly I am saying is that if any value in that (V_BI_AGING.AMT) that meet the conditions then I will place them in the detail sections.
 
 
if date(year(today()),month(today()),day(today()))>31 +{V_BI_AP_AGING.DUE_DATE} and date(year(today()),month(today()),day(today()))<60 + {V_BI_AP_AGING.DUE_DATE}then {V_BI_AP_AGING.AMT}
 
Numbers from the formula are great, but when i try to make a summary field using RUnning Total gives me a crazy number it didnt added up the number from the formulas above.
 
Any helps would be great!!!!!
IP IP Logged
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.032 seconds.