The above script Description field includes following data
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 Description field.
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
Why not using Preceding load or may be Resident load by help of Group By with in the script?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
