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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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)