To add Value in Field

[abhaysingh]

Hi Every one

Can Any one pls help me in this below..

I have one table which contain a field FIELD1 having four value in that i.e. cost, revenue, Deprecation, Amortization and i want to add Gain, Ebit, Gain %, Ebit% in same Filed FIELD1

HOW i can do this

[robert_mika]

How does your data set look like?

Are the fields to be added coming from different data set or are they calculated?

If the latest, how?

[abhaysingh]

they are calculated like for gain it is some of Revenue + Cost ans so on

[alexandros17]

Load FIELD1 resident myTable;

concatenate

Load * inline [

FIELD1

Gain,

Ebit,

Gain %,

Ebit%

];

let me know

[robert_mika]

Does your data model look similar to this?

Field1	Field2
Ravenue	100
Cost	200
Depraciation	300

[abhaysingh]

yes now i want GAIN which is the sum of Revenue+Cost,, and so on