• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

Group Footer Variable

OK Now I return the scrap amount in my details section. I need to return that total amount of scrap time in my group footer equation.

How can I just pass the value of my details running total to my footer?
1 Solution
cmdolcetAuthor Commented:
Never mind I figured out my issue

Shared NumberVar scrapped_Time;
numberVar dur := scrapped_Time;
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

hhmmss := totext(hrs,"0") + ":" + totext(min,"00") + ":"+ totext(sec,"00");
As you figured out, you just needed to use the scrapped_Time variable.  FWIW, you don't need the dur or hhmmss variables in that formula.  You could just use scrapped_time instead of dur, and you don't need to put the final string in a variable unless you want to use that string somewhere else.  So, you could have:

Shared NumberVar scrapped_Time;
numberVar hrs;
numberVar min;
numberVar sec;

hrs := Truncate(Truncate(scrapped_Time/60)/60);
min := Remainder(Truncate(scrapped_Time/60),60);
sec := Remainder(scrapped_Time,60);

totext(hrs,"0") + ":" + totext(min,"00") + ":"+ totext(sec,"00")

 And if you really want to cut down the formula as much as possible, you could eliminate all of the variables except for scrapped_Time:

Shared NumberVar scrapped_Time;

totext (Truncate (Truncate (scrapped_Time / 60) / 60), "0") + ":" +
 totext (Remainder (Truncate (scrapped_Time / 60), 60), "00") + ":"+
 totext (Remainder (scrapped_Time, 60), "00")

 As far as performance goes, I don't think it makes any difference which formula you use.  It's all about which version you (or anyone else that might look at this report) find easiest to read.  I was just presenting some alternatives, FYI.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now