TM1 Forum

Hello Jim after a few days I managed to fix the issue. The problem was that I was combining too much Excel functions and calculations. I created a calculation cube where I stored all my values (that I needed, but invisible for the end user). All other calculations are now implemented in rules and it...

Hello Jim

thanks for the feedback. Yes, I added it in another cell. I've rebuild the sheet and uploaded it on the application.
Please see the difference in the attached images.

It is the 'modifier' value that is empty and where I entered the formula.

Hello all, I have an active form (Perspectives) where everything works fine; I have a cell referring to the last element of a dimension, and picking a measure in it: =DBRW($B$9;$C$17;$C$19;$C$20;$C$21;DIMNM("PriceTool:Modifiers";DIMSIZ("Pricetool:Modifiers"));J$32) However, when ...