Hi,
I am using Hyperion Planning 11.1.2.5.600, and I had a formula column and formula row in a data form. The formula column [D] = ([A]-[B]) * [C], and the the formula row [3] = SUM([1:2]). The problem is at cell [D,3], the value would be ([A]-[B]) * [C], not SUM([1:2]). Is there any way I can set the cell value [D,3] as SUM([1:2]) and keep everything else 'as is'.
What makes it a little more tricky, is that there are multiple formulas in the rows and columns and at different intersections, I want the "default" formula to be the ROW at one section and then at another point I want the COLUMN formula to be the default.
Any suggestion will be highly appreciated.
Thank you.