Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum(Data)/Sum(total <Year> {<Description={'Total wealth created'}>} Data)