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 Logged