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