TM1 Forum

Hi

On some reports users want the ability to see figures in Units, Thousands, Millions, etc.

We implemented this with a lookup and that gives a scale divisor of 1, 1000, 1,000,000 and then our DBRW formula were dividing by rScaleDivisor.

This worked fine in Active Forms in 10.1 TM1 Web.

However, it does not work reliably in PA TM1 Web. In some cases the report never finished running. Even worse, in other cases it appears to cause some lines to be randomly omitted from the reports.

The work around and arguably the better approach is to create consolidation measures above the unit level measure and use weights to divide by 1000 eg

Millions weight 0.001
Thousands weight 0.001
Units

Then the lookup from Units, Thousands, Millions, just needs to select the appropriate measure which is then referenced in the Active Form DBRWs.

Regards

Paul Simon

If you don't care about the footings at the bottom (i.e., no rounding) then you can also do the same with conditional numeric formatting in your report. Have the conditional formatting change based on your selector drop-down. I've done the same thing a few times before and it works fine.

paulsimon wrote: ↑Wed Feb 20, 2019 11:05 am
The work around and arguably the better approach is to create consolidation measures above the unit level measure and use weights to divide by 1000 eg

Then the lookup from Units, Thousands, Millions, just needs to select the appropriate measure which is then referenced in the Active Form DBRWs.

True. Because if I’m not mistaken TM1 treats =DBRW/1000 as DBR, isn’t it ?