Pada dasarnya cuman meng-assign minus pada data yang C, Coba aja hilangin function SUMnya, you'll see..
On 7/20/06, aan <[EMAIL PROTECTED]> wrote: > > mas wahyu, > > nyambung lagi nich..! > > di table seperti ini > > ACCOUNT_NO AMOUNT > D 500 > C 400 > D 200 > C 100 > > Note : > D = Debet > C = Credit > > > SUM( DECODE(ACCOUNT_NO,'D', AMOUNT, AMOUNT * (-1))) > > dengan menggunakan fungsi tsb bagaimana hasilnya....? > asumsi saya fungsi -1 itu menjumlahkan yg kredit bener ga yach....? > > tks > aan > > > ----- Original Message ----- > From: "Wahyu Candra Utama" <[EMAIL PROTECTED]<wahyu.candra%40globaltv.co.id> > > > To: <[email protected] <indo-oracle%40yahoogroups.com>> > Sent: Thursday, July 20, 2006 3:08 PM > Subject: RE: [indo-oracle] Fungsi sum dalam decode > > > > > Arti SUM( DECODE(ACCOUNT_NO,'D', AMOUNT, AMOUNT * (-1))) itu kalo > > diartikan > > * Jika ACCOUNT_NO = 'D' maka nialianya = sum(amount) --> > > * Jika ACCOUNT_NO != 'D' maka nialianya = sum(amount* -1) > > Amount * (-1) ==> amount * negatif > > > > Semoga membantu > > > > > > > > > > -----Original Message----- > > From: [email protected] <indo-oracle%40yahoogroups.com>[mailto: > [email protected] <indo-oracle%40yahoogroups.com>] > > On Behalf Of aan > > Sent: Thursday, July 20, 2006 2:48 PM > > To: [email protected] <indo-oracle%40yahoogroups.com> > > Subject: [indo-oracle] Fungsi sum dalam decode > > > > Dear All, > > > > Mohon Bantuannya ......! > > > > > > > > saya mendapatkan script di sebuah buku oracle yaitu fungsi sum di dalam > > decode ..! > > saya kesulitan mengartikan arti * (-1) dalam fungsi decode > > > > SUM( DECODE(ACCOUNT_NO,'D', AMOUNT, AMOUNT * (-1))) > > > > Tolong penjelasan dari script di atas > > > > Best Regards > > Aan Angsori,SE > > EDP Department > > PT.Nikomas Gemilang > > [EMAIL PROTECTED] <aan%40pci.co.id> > > 0254 - 401586 Ext: 7192 > > > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED]<indo-oracle-unsubscribe%40yahoogroups.com> > > Website: http://indo-oracle.blogspot.com > > Mirror: http://indooracle.wordpress.com > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.blogspot.com > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED]<indo-oracle-unsubscribe%40yahoogroups.com> > > Website: http://indo-oracle.blogspot.com > > Mirror: http://indooracle.wordpress.com > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.blogspot.com > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
