RE: [sqr-users] PeopleSoft SQR question

["Hall, Tara" <hallt@talgov.com>]

Hi Don,

I used your suggestion to divide by 100.  It worked.

Thanks a lot.

-----Original Message-----
From: sqr-users-bounces+hallt=talgov.com@sqrug.org
[mailto:sqr-users-bounces+hallt=talgov.com@sqrug.org]On Behalf Of
don.barclay@srs.gov
Sent: Monday, November 06, 2006 5:14 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] PeopleSoft SQR question


Hi Tara,

It would help if you could be a little more descriptive about your 
problem.  If I am reading your question correctly, you are trying to enter 
a number where the first x digits are the dollar amount, and the last two 
digits are the cents.  You could read in the amount, verify that input is 
as expected (make sure that every value is a digit, for example), and then 
divide the resulting number by 100.

HTH,
Don

> Hi,
> 
> I have an sqr that is reading a flat file and populating a table. 
> I'm encountering an issue with the handling of a dollar amount.  The
> last two digits should be the cents amount.  However, I can't 
> determine where the dollars and cents are being manipulated in the 
> process.  My short term fix was to change the field positions to get
> the correct dollar amounts.  This only works because in this 
> particular flat file there are no dollar amounts with cents.
> 
> Any suggestions.
> 
> Thanks.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users