I want to get a sum of the total amount of days that's being calculated by my formula field. If I use the insert summary tool than it ask me to select a report field to summarize and doesn't give me the option to summarize a formula field.

Any help would be great!

I have crystal reports 2008

NumberVar TotalDays;
NumberVar TotalWeekEndDays;
NumberVar SecondsTook;
NumberVar HoursTook;
NumberVar DaysTook;
StringVAR TimeTaken;

TimeTaken := "No Dates";
    
TotalWeekEndDays := (DateDiff( "ww", {#SoCommentDateRt},{#MemApptDateRt},2)*2);

// Calculate work days took



TotalDays := Round((DateDiff( "d", {#SoCommentDateRt},{#MemApptDateRt},2) - TotalWeekEndDays ),0);


HoursTook:= (DateDiff( "h", {#SoCommentDateRt},{#MemApptDateRt},2));

SecondsTook:= (DateDiff( "s", {#SoCommentDateRt},{#MemApptDateRt},2));





   
if SecondsTook = 0 Then
      TimeTaken := ("Open")

   else if (TotalDays) > 0 Then
       
      TimeTaken := (TotalDays & " Day/s")

   else if HoursTook > 0 Then

       TimeTaken := (HoursTook & " HOUR/S")
   
    else
        TimeTaken := ("15 minutes") ;   






I probably will edit it and have anything < 1 Day just rounded up to '1 day' and anything = 0 Seconds '0'

Edited by Ohmsy - 13 Jul 2010 at 3:37am

So there is no possible way to sum a string?

If i changed my formula to


f SecondsTook = 0 Then
      TimeTaken := ("0")

   else if (TotalDays) > 0 Then
       
      TimeTaken := (TotalDays)

   else if HoursTook > 0 Then

       TimeTaken := ("1")
    
    else
        TimeTaken := ("1") ;   


Would that work?

sorry for the spoon feeding but i'm new to all this, if I changed it to a numbervar instead of a stringvar would I still be able to get my results?