TM1 Forum

Hi. I browsed through a number of threads on OF before launching this thread and found some pretty good tips on other topics, but this one is still a mystery. Apologies if it has already been addressed ...

I have a need to generate blank rows beneath n-level rows in an active forms area. I'd like to put some excel calculations in the blank rows. Said another way, I'd like to have a row of DBRWs, then a blank row with a formula referencing the DBRW output above, then a blank spacer row, then the next row of DBRWs. This repeats for all elements in the subset.

Any thoughts?

Thanks,
Chris

Not much time just now so very quickly:

All rows of an active form contain the same formulas as formulas are copied down from using the first row of the active form as a formula template. Active forms can contain differential formats by row but cannot contain different formulas between rows.

As mentioned, the active form code just copies the formulas down. There is no requirement the formula be a straight DBRW or DBRA or whatever. You can have an IF formula like IF(EvenLineNumber,DBRW(Cube,DIm1,Dim2,Dim3...),MakeCellBlank) where one of the columns to the left (inside the fomatting range) counts the row numbers so you can use that to determine if it is Even. Use your imagination

Thanks for the comments. I figured that's what I was dealing with ... wasn't sure if anyone had thought up a workaround. It seems like a useful feature to me, just in case any IBM TM1 developers are listening in.