needmoremoney
Technical User
Hello All,
I have this to count records from a Detail section of a Group setting:
stringvar TotString:="";
TotString := "T4" + {@TotalEEs} + {@TotalSpaceFill} + chr(013);
TotString;
................
the formula for the TotalEES is :
numbervar reqlength := 11;
stringvar string := totext(Count ({@EESSN}, {Query1.id}), "00");
numbervar currlength := length(string);
if currlength > reqlength then
string := string[currlength - reqlength]
else
string := replicatestring("0", reqlength-currlength) + string;
.............
My problem is that I suppress duplicate values, the formula above counts them as well. Is there a way to not include the supressed, duplicate values in my count formula?
Thanks for any response.
I have this to count records from a Detail section of a Group setting:
stringvar TotString:="";
TotString := "T4" + {@TotalEEs} + {@TotalSpaceFill} + chr(013);
TotString;
................
the formula for the TotalEES is :
numbervar reqlength := 11;
stringvar string := totext(Count ({@EESSN}, {Query1.id}), "00");
numbervar currlength := length(string);
if currlength > reqlength then
string := string[currlength - reqlength]
else
string := replicatestring("0", reqlength-currlength) + string;
.............
My problem is that I suppress duplicate values, the formula above counts them as well. Is there a way to not include the supressed, duplicate values in my count formula?
Thanks for any response.