4 Replies Latest reply on May 28, 2015 3:01 PM by BrianMatthews

    Not getting data I need in the report creator or as exported to excel data

    BrianMatthews

      Title

      Not getting data I need in the report creator or as exported to excel data

      Post

      I am new to FM. I have a layout were service times (in hours) are calculated from a start time to an end time. The format is HH:MM:SS and in the calculation it is a text output. On the layout in the field the number is correct. When I try to do a subtotal though I just get zeros and when I export the data to excel it will not sum although if I do f2+f3+f4 etc I do get the right total. When I try to use the report creator all the summary fields are "grayed" out. I pasted an image of the report screen.

      Any ideas on a solution, please!
       

       

       

      report_question.png