Get the first record

Hi!

I have one computed column which retrieve the first record of a column named "DEP", I used the aggregation "First" to do that! Then, I want to reuse it to another computed column but I couldn't get its value.
My questions are:

- is it impossible to get a value of a computed column which uses Aggregation to another one?
- is there another way to get the first record by using function not Aggregation?

Here is I want to do:

1)DEP: First(row["DEPARTEMENT"])
2)DEP2: if(A==null {DEP **}else {DEP1}
I couldn't get **

My best regards!

Solofo

Find more posts tagged with

Comments

mwilliams

Hi Solofo,

What is your BIRT version?

As far as what you're trying to do, you want to make a computed column that grabs the first value of a certain column. Then you want to use this value for another computed column if "A" is equal to null? Does the value of DEP ever change or is it always the same value?