Hi,
I have a problem with my matrix.
The following matrix is working fine :
|Based Column | Repeating Cols | Sum of repeating cols | Formula
------------------------------------------------------------------------------
| A | B1 | B2 | B3... | Sum(B) | X = A - Sum(B)
------------------------------------------------------------------------------
TOTALS| Sum(A) | | Sum(Sum(B)) | Sum(X)
I would like to add a break group above this matrix, to display the type :
Type : Type1
|Based Column | Repeating Cols | Sum of repeating cols | Formula
------------------------------------------------------------------------------
| A | B1 | B2 | B3... | Sum(B) | X = A - Sum(B)
------------------------------------------------------------------------------
TOTALS| Sum(A) | | Sum(Sum(B)) | Sum(X)
---------------------------------------------------------------------------------
/*******************************************************************************/
---------------------------------------------------------------------------------
Type : Type2
|Based Column | Repeating Cols | Sum of repeating cols | Formula
------------------------------------------------------------------------------
| A | B1 | B2 | B3... | Sum(B) | X = A - Sum(B)
------------------------------------------------------------------------------
TOTALS| Sum(A) | | Sum(Sum(B)) | Sum(X)
Everything compiles fine.
At execution, the first pages are calculated fine, but the last page goes in exception :
REP 1510 : Groupe Manager : unable to calculate the 'X = A - Sum(B)' column.
I tried to put columns : A, Sum(B), X at the same level, another error comes.
Any help/hint/advise would be appreciated.
Thanks,
Vincent
I have a problem with my matrix.
The following matrix is working fine :
|Based Column | Repeating Cols | Sum of repeating cols | Formula
------------------------------------------------------------------------------
| A | B1 | B2 | B3... | Sum(B) | X = A - Sum(B)
------------------------------------------------------------------------------
TOTALS| Sum(A) | | Sum(Sum(B)) | Sum(X)
I would like to add a break group above this matrix, to display the type :
Type : Type1
|Based Column | Repeating Cols | Sum of repeating cols | Formula
------------------------------------------------------------------------------
| A | B1 | B2 | B3... | Sum(B) | X = A - Sum(B)
------------------------------------------------------------------------------
TOTALS| Sum(A) | | Sum(Sum(B)) | Sum(X)
---------------------------------------------------------------------------------
/*******************************************************************************/
---------------------------------------------------------------------------------
Type : Type2
|Based Column | Repeating Cols | Sum of repeating cols | Formula
------------------------------------------------------------------------------
| A | B1 | B2 | B3... | Sum(B) | X = A - Sum(B)
------------------------------------------------------------------------------
TOTALS| Sum(A) | | Sum(Sum(B)) | Sum(X)
Everything compiles fine.
At execution, the first pages are calculated fine, but the last page goes in exception :
REP 1510 : Groupe Manager : unable to calculate the 'X = A - Sum(B)' column.
I tried to put columns : A, Sum(B), X at the same level, another error comes.
Any help/hint/advise would be appreciated.
Thanks,
Vincent