TM1 Forum

The main issue here is that you are not dealing with a serial number that can be formatted. If you divide your 1234.75 by 24 and apply a format of hh:mm to the result you end up with something like 10:45 but miss the other 19 days as the formatting would now want to convert the serial number to a p...

Thanks for the suggestions Maren + Wim,

Unfortunately I think you're right in that it can't be done with native number formats

Rob

Hi Wim,

In general, all of them, but specifically PAW and/or TM1Web.

Hi All, I have some decimal hour values that I want to be able to display in hh:mm format. This works ok for values < 24 hours, but I'd like the aggregated numbers to display the same as Excel's [hh]:mm number format e.g. 1,234.75 hours in decimal hours should display as 1234:45 in hh:mm. Is this po...

duh, of course - thanks for the reminder of why!

this might be a bit of a newb question but are there any issues caused by OptimusPy when it moves the measures dimension to a position other than the last?

Regards,

Rob