Home » Developer & Programmer » Reports & Discoverer » sum a varchar2 field in report builder
sum a varchar2 field in report builder [message #88939] Tue, 24 June 2003 15:22 Go to next message
dmc
Messages: 3
Registered: June 2003
Junior Member
The Tables I am using are in Oracle Human Resources Appications. The Hr_all_positions_f table has an budgeted salary amount stored in the Attribute4 field. How do I SUM these values in a report using Oracle report builder? The field is defind as a Varchar2.

Thank You.

Report message to a moderator

Re: sum a varchar2 field in report builder [message #88955 is a reply to message #88939] Mon, 07 July 2003 01:53 Go to previous message
sujit
Messages: 94
Registered: April 2002
Member
hi,
convert to number then sum up. sum(to_number(substr(X,i)))
Sujit

Report message to a moderator

Previous Topic: How to do this - Newbie ??
Next Topic: Problem with paper size in Reports Builder
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 21:10:52 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.