How to format key figure (DD:HH) with Bex Query and/or Design Studio

[former_member555322]

Hello Gurus,

I need to display a lead time between two dates with the format Days Hours.

Example with the standard key figure in first colum and my target with the format in the second column:

Do you know a way to implement this kind of key figures format with the tools BEx query (7.4) and Design Studio 1.6 SP2 ?

In the Bex, the function TIME make some similar transformation in format HH:MM:SS.

For the moment, I display in one key figure the days in the integer part and the hours in the decimal part :

My business are not agree with this solution and need somethong more user-friendly.

The business use also the soft Spotefire and it is very simple to apply format to the key figures.

I have also propose to use two key figures (one for days and second for hours) but this has also been rejected by the Business .

Thanks for help,

Franck

[sapna_jgurudutt]

Hi Franck,

Do you also want to have this using Design Studio here?

Thanks & Regards,

Sapna

[former_member555322]

Hello Sapna,

Yes, the final goal is to display the report in Design Studio.

Regards,

Franck