TM1 Forum

Hi! Can you tell a little bit more about your issue? Did you create your view from CubeViewer and didn't modify anything? If you modify few things, then it may be for multiple reasons. When you edit your formula in Excel (F2) and then validate your formula, do you get your number? If yes, check your...

Tell me if it worked

I think that you want to retrieve the variable name from the concatenation of 'Departement_' and a number i in your while. I think that you should try the "Expand" function. Something like that " expand('%Departement_'|numbertostring(i)|'%') " should give you the variable value. ...