AnsweredAssumed Answered

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

Question asked by BrianMatthews on May 28, 2015
Latest reply on May 28, 2015 by 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

Outcomes