Creating Blank Rows For Calculation - Active Forms

[cbeycwright]

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

[lotsaram]

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.

[tomok]

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

[cbeycwright]

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.