Skip to Content
avatar image
Former Member

Top N formula Based on CKF

Hello SDN Gurus!

I have the Top N formula in my query.

Top N formula: ZFormula = (AmountInt_Rate)0.01.

But it doesn't work properly.

My requirement to list Top N Customers based on ZFormula. But my report looks like this:

Customer	Line_Of_Credit	Tranche	    Amount	Int_Rate 	ZFormula
ZCOM AG	           LOC001 	TR001	     100	10	        10
                                TR002        50         10               5
                   LOC002 	TR005	     25         10	        2.5
Result                                       175        10              17.5

Gen BV	           LOC007 	TR008	     200	25	        50
                                TR009        150         25             37.5
                   LOC010 	TR011	     300         25	        75
Result                                       650        25              162.5

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 09, 2010 at 07:39 AM

    Hi,

    Chose the option below for evaluating conditions -

    All characteristics in the drilldown independently

    Hope this helps!

    Regards,

    Saurabh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi, already done. I selected this feature for Customer characteristic. May be it's a limitation of Top N formula? It works fine just for formulas based on a summation operation.When I/m trying to use this formula just on an Amount key figure, report works perfectly.

  • avatar image
    Former Member
    Apr 16, 2010 at 06:28 AM

    Solved with using special aggregation.

    Add comment
    10|10000 characters needed characters exceeded