My Cube view has entities in rows. One of the rows is a sum of several
entities ( E#A1+E#A2+E#A3). In the 4 columns I have Actual, Budget,
Variance and Variance%. Variance and Variance % being calculated from
the two first columns. Works fine except ...
I have CV - rows with Accounts as Expansion 1 , and three Origin-member
as Expansion 2. I'd like to have the Accounts as suppressed if zero ( no
problem) but when I open the +-sign to see the Origin members for
selected account I want all three (Form...
In theory yes, but I don't think it references the summed value - I have
had problems with this before. The definitions are for column 3:
GetDataCell(CVC(actual)-CVC(budget)):Name(Var mkr) and for column 4: