Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
tracycrown
Creator III
Creator III

% computation

Dear all

Kindly advise how to write a correct expression to compute the % column shown below :

Description 2022  %
Sales Revenue 806,900 93.7%
Purchased materials and services : 54,250 6.3%
Total wealth created 861,150 100.0%
Staff costs 385,000 44.7%
Directors' fee   0.0%
Directors' remuneration 0 0.0%
Central provident fund 0 0.0%
Medical expenses 0 0.0%
Training 0 0.0%
Property tax 273,000 31.7%
Foreign worker levy 0 0.0%
Income tax 9,601 1.1%
Bank interest and charges 0 0.0%
Interests 42,000 4.9%
Dividends 0 0.0%
Depreciation 24,000 2.8%
Retained earnings 127,549 14.8%
Total wealth distributed 861,150 100.0%

 

Thank you, Tracy

 

Labels (1)
1 Reply
hic
Former Employee
Former Employee

Sum(Data)/Sum(total <Year> {<Description={'Total wealth created'}>} Data)