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)