Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
they are calculated like for gain it is some of Revenue + Cost ans so on
Load FIELD1 resident myTable;
concatenate
Load * inline [
FIELD1
Gain,
Ebit,
Gain %,
Ebit%
];
let me know
Does your data model look similar to this?
Field1 | Field2 |
Ravenue | 100 |
Cost | 200 |
Depraciation | 300 |
yes now i want GAIN which is the sum of Revenue+Cost,, and so on