formula on summarized cross tab field

[Former Member]

Hi!

I am calculating a sum of time period in seconds using a cross tab(CR XI). The result is fine, but is it possible to convert it into HH:MI:SS?

Thanks,

Yuanyuan

[Former Member]

Use GridValueAt()

[Former Member]

HI

Try the following formula :

totext(abs({database.field} / 3600),"00") & ":" &

totext(abs(remainder({database.field},3600) / 60),"00") & ":" &

totext(abs(remainder(remainder({database.field},3600),60)),"00");

Thanks,

Sastry

[Former Member]

Thank you for the nice formula.

The point is, where to put it into the report. As a summarized field, the result of the formula is going to be aggregated too. How could we make the formula access values in the cross tab without being evaluated by the cross tab itself?

Yuanyuan

[Former Member]

Hi

Right click on the field where you want to insert this formula go in format fieldcommondisplay string

here you place this formula.

Thanks,

Sastry

[Former Member]

Thank you again for the tip.

Unfortunately, CR doesn't seem to be able to read each summarized field value at runtime this way. On modifying the display string, all the fields are made equal.

Any new ideas?

Yuanyuan