Custom Date/Time formatting

[jonhoward]

This should be so simple.....

I have a base metric Sum(seconds)

I have a metric to convert this figure to a timestamp (Sum(seconds) / (60*60*24)), with dd"d"hh"h"mm"m"ss"s" as the Custom format

If the number of seconds equates to greater than a day, then the time is displayed correctly. However if the number of seconds equates to less than a day that cell displays ###########

eg number of seconds timestamp
1000 ###########
2000 ###########
... ...
111532 01d06h59m02s
296678 03d10h24m58s

What am I doing wrong?

Desktop 8.0.2, teradata

 

[FLB]

Is your column wide enough on the grid?
Is the data type you are using for the column wide (big) enough to store such large number (if not look at the new BIGINT support in 8.0.x)