Skip to Content
0
Former Member
Jan 22, 2009 at 04:02 PM

Individual Cell Referencing

27 Views

Hi All,

This thread actually follows on from another, which you can find here:

I don't believe it is possible to reference specific cells in a table in the manner you have described. You can reference the cells in an individual selected row of a table by using the corresponding field/column name. However, I don't think you can reference individual cells anywhere in the table like you can with Excel spreadsheets for example.

Judging from the response quoted above, it will be possible to calculate values for Column4, if:

Column4 = Column2 + Column3.

Example 1

--


Column1
Column2
-- -Column3 -----Column4

Row 1 -


80--


85
95
--


180

Row 2 -


100--


130
160
--


290

Row 3 -


200--


210
220
--


430

Row 4 -


200--


240
260
--


zzz

But it will not be possible to calculate values for Column4 , if:

Column4 = a value from another row Column1 + value from row in Column2.

Example 2

--


Column1
Column2
-- -Column3 -----Column4

Row 1 -


80--


85
95
--


185

Row 2 -


100--


130
160
--


330

Row 3 -


200--


210
220
--


410

Row 4 -


200--


240
260
--


xyz

It is highly desirable to be able to reference particular cells and their values in order to be able to manipulate them a little further (as this info is not available at BI Cube level; arrives from different BI queries).

Is anyone able to confirm please?

Regards,

Chet.