Not getting data I need in the report creator or as exported to excel data
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!