TM1 Forum

Exactly what we need in our environment as well. Meanwhile is there any workarounds available before TM1 evolves to that capability? Thanks.

blackhawk wrote:Hmmm....that is interesting...have you tried this in 10.2.2 yet?

Nope.... not yet. Anyone tried it please let us know.

This might work: =IF(TEXT(A1,"@")=TEXT(B1,"@"),TRUE,FALSE) That way its apples and apples. Note there's no need to quote the TRUE and FALSE outcomes otherwise you will be casting strings back to booleans. Thanks Robin for the good code suggestion. What does the @ symbol do as pl...

There is a discrepancy observed on Excel formula behaviors in TM1Web and Perspectives regarding a number wrapped in double quote marks. We tried to use IF formula to compare whether a simple number (say, a number 5) equals to a specific value. We found that in Excel the IF statement will return FALS...

Appreciate so much your helpful reply...... I think I'm close to the answer now. This bug happens to the TM1 client installed on 'Chinese' locale OS but doesn't occur on English locale OS. So in summary seems the TM1 excel add-in (2003) doesn't paste the full formula to the A column in a non-English...

Wim Gielis wrote:What are the specific TM1 versions (and subversions)?

I can at least specify two cases:
1) TM1 32 bit server = 9.4.1 (FP3); 32 bit client = Perspective 9.4.1 (FP3)
2) TM1 64 bit server = 9.4.1 (FP3); 32 bit client = Perspective 9.4 MR1

It should be the problem of TM1 client. The function works well on one colleague's PC. However it remains broken on mine, connecting to the same TM1 server.

Is it possible related to re-installation of TM1 client?

Hi Wim, Thanks for reply. It seems to me this broken function is occurring to many kinds of dimensions / cubes / views, at least in two of the projects I've worked with. The function is something used to determine whether the row element is a simple one or a consolidated one, and also what's the lev...

I'm using the Active Form in TM1 9.4.1. In the beginning (right after I installed the TM1 server & client), the "IF" function in column A worked well. It returns the level of the corresponding element of that row. Active Form sets the format for that row depending on the returned value...