Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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