Skip to Content
avatar image
Former Member

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

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 24, 2017 at 06:01 AM

    Hi,

    Create a restricted key figure with constant selection on Fund 1.

    regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 25, 2017 at 01:11 PM

    Hi use formul SUMGT

    Add comment
    10|10000 characters needed characters exceeded