Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sagaraperera
Creator
Creator

PROFIT

DEAR ALL

PLEASE HELP GET A ANSWER IN FOLLOWING

DESCRIPTION ACTUAL  
POLICY_FEES 30,180  
GROSS_PROFIT 5,000,052 A
STAFF_EXPENSES 914,995  
ADMIN_EXPENSES 2,275,399  
SELLING_EXPENSES 964,524  
FINANCIAL_EXPENSES 12,874  
DEPRICIATION_EXPENSES 23,460  
MANAGEMENT_EXPENSES 4,191,252 B
INV_INCOME_INT 5,084  
OTHER_INCOME_EXT 0  
OTHER_INCOME_INT -34,122  
INV_OTHER_INCOME -29,038 C
     
NET_PROFIT A-B+C  
     
ANSWER 779,762  

 

SANKA

 

Labels (1)
2 Replies
Rajashekar
Contributor III
Contributor III

hi @sagaraperera 

can you provide more details on exactly what you are looking for?

 the above one you asked for is a simple calculation. you can do it by preceding load if the first column is a list of fields.

sagaraperera
Creator
Creator
Author

Dear Rajeshkar

please find the below attachment and i want get a net profit value in calculation. please help

 

sagara