TM1 Forum

I have a dimension with mixed data types. The two data types are 4 dpl and %. I understand how to format different levels in an active form but how do i format the dimension with mixed data types where the elements are both at the lowest level? Thanks for any input!

Hi

And why not putting the measures in the columns?

Hi Wim,

Thanks for your reply. I need to have the time dimension in columns. For instance, you would have have the months in columns from Jan to Dec and the measures dimension in rows where you would have the two different data types.

Put an attribute against your measure dimension that identifies it as either 4dp or pc.

Next, change the IF(TM1RPTELISCONSOLIDATED... formula in column A (assuming you haven't added any extra columns yourself) to concatenate the attribute on the end.

Then insert extra rows as necessary in the format area, change the values in column A to 04dp, 0pc etc and format the rest of the format range as appropriate.

Andy Key wrote:Put an attribute against your measure dimension that identifies it as either 4dp or pc.

Next, change the IF(TM1RPTELISCONSOLIDATED... formula in column A (assuming you haven't added any extra columns yourself) to concatenate the attribute on the end.

Then insert extra rows as necessary in the format area, change the values in column A to 04dp, 0pc etc and format the rest of the format range as appropriate.

That works?

My work around was having a sheet with the correct cell formating in a range and running a macro over the active form to fix the formatting.

I will give the above a go and see what happens.

vaneagle wrote:That works?

My work around was having a sheet with the correct cell formatting in a range and running a macro over the active form to fix the formatting.

I will give the above a go and see what happens.

A bit of experimenting never goes astray ...

You can insert as many additional rows into TM1RPTFMTRNG as you need and likewise you can change the format key values in TM1RPTFMTIDCOL with whatever you like and the formulas in the format column to the left of "=TM1RPTROW(....." do not have to be "=IF(TM1RPTELISCONSOLIDATED(.....", they can be changed to whatever you like. One easy alternative is to create a formatting attribute and use DBRA.

Active Forms are very flexible, you are not limited to what comes straight out of the box.

Thanks everyone for you replies. I'm going to amend the formulae and see if I can get it to work. I will keep you updated.