Skip to Content
0
Former Member
Apr 09, 2010 at 06:59 AM

Top N formula Based on CKF

53 Views

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