Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question