formulla

[sagaraperera]

Dear ALL

I HAVE GIVEN BELOW SCRIPT

CrossTable(cata, Data,3)

LOAD BCOD,

     Category,

     Description,

FR

MR,

SS

The Description includes following categories

GROSS PROFIT

Direct Expenses

Apportioned Direct Expenses

Indirect Expenses

Mgt Fee - Apportioned Indirect Expenses

Direct - Other Income

Indirect Income - Investment

I need to derive following formulas by using above category of data

01.

GROSS PROFIT-Direct Expenses-Apportioned Direct Expenses as Profit_aft_Direct_Expenses

02.

GROSS PROFIT-Direct Expenses-Apportioned Direct Expenses+Direct - Other Income as Profit_aft_Direct_Expenses_Income

03.

GROSS PROFIT-Direct Expenses-Apportioned Direct Expenses+Direct - Other Income -Indirect Expenses-Mgt Fee - Apportioned Indirect Expenses  as Net_Profit_Before_Income

04.

GROSS PROFIT-Direct Expenses-Apportioned Direct Expenses+Direct - Other Income -Indirect Expenses-Mgt Fee - Apportioned Indirect Expenses+Indirect Income - Investment as Net_Profit_Before_Income

sagara

[Siva_Sankar]

Hi Sagara,

You can create a calculated field like below and then use it in expression.

Load *,

if(Category='GROSS PROFIT',Category) as GROSS PROFIT,

if(Category='Direct Expenses',Category) as Direct Expenses,

.....

......

....

FROM YOUR TABLE;

-Siva