Skip to Content
0
Jul 24, 2017 at 03:16 AM

How to create query key figure is divided by overall result of another key figure

63 Views

User ask me to create query below.

Please help me with this?

				        KF1	KF2	  **Expected Column**
Fund 1			 	30	17.5	  = 17.5/30 = 0.58
	Functional Area 1	10	10	  = 10/30	 = 0.33
	Functional Area 1	15	5	  = 5/30	 = 0.17
	Functional Area 1	5	2.5	  = 2.5/30	 = 0.08