Skip to Content
0
Former Member
Oct 21, 2009 at 09:39 AM

Time Key figure addition

43 Views

Hi Gurus,

In an infocube, I work with a Key figure defined as Time (hhmmss). the aggregation "Sum" in Bex is done correctly as the sum doesn't exceed 24H.

After this value, the key figure is re initialize. Thus, I can't sum time.

Below, result of my query

user name Time

BOUSYL 12:32:34

BULARP 18:31:44

DAN_SEB 00:15:50

Sum 07:20:08

Sum shoud be 31:20:08, system display 07:20:08 (31:20:08 - 24:00:00)

Should I use a different key figure type or define a time stamp to successfully add my time

Thanks for your help

Thierry