Top N formula Based on CKF

[Former Member]

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

[Former Member]

Solved with using special aggregation.

[Former Member]

Hi,

Chose the option below for evaluating conditions -

All characteristics in the drilldown independently

Hope this helps!

Regards,

Saurabh

[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.