Sum a Time Using this Formula

[dbielenda]

Hi all,

I am using this formula to get my time:

ToText((({TABLENAME.FIELD}\60) Mod 24),0) + 'h, ' +
ToText(({TABLENAME.FIELD} Mod 60),0) + 'm'

then I grouped by this time and I want the grand total of these times, however, the sum feature is not available. Anyone know why?

Thank you!

 

[dbielenda]

Is it because it is ToText? How can I chnage this formula to get a sum?

 

[dbielenda]

Is it because it is ToText? How can I change this formula to get a sum?

 

[FoxG]

Hi,

I think it is due to the fact that you trying to do a action which is performed during a processing phase earlier than group summing which is done whileprintingrecords.

You may be forced to use formulae to create your sum totals.

Hth,
Geoff

 

[dbielenda]

I have never used the whileprintingrecords, could you show me a formula on how I can incorporate this with the formula I already have?

 

[dbielenda]

What I ended up doing was this:

1.) Create a sum of my numeric field by first placing the field onto my report. Right mouse click, insert, summary.
2.) Incorporated this sum into my formula to get a grand total:
ToText(((Sum (TABLENAME.FIELD}\60) Mod 24),0) + 'h, ' +
ToText((Sum ((TABLENAME.FIELD}) Mod 60),0) + 'm'