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