Conditional Running Totals
Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19006
Printed Date: 27 Apr 2024 at 5:20am
Topic: Conditional Running Totals
Posted By: guy723
Subject: Conditional Running Totals
Date 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!!!
 |
Replies:
Posted By: guy723
Date 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!!
|
Posted By: guy723
Date 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!!!!!
|