×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
%dec(char : 11 : 4) the 4 represents the precision you wish in the result.
So you are actually getting the value 00000639000.0000 with the precision of
4 decimal positions.
Where the 4 comes in to play is when you desire a certain amount of
precision in your calculation.
Lets pretend pi = 22 / 7.
area = (22 / 7) * r^2
If you want 22 / 7 to be accurate to 4 decimals then
Area = %Decimal((22 / 7): 4) * r^2.
If you want 22 / 7 to be accurate to 10 decimals then
Area = %Decimal((22 / 7): 10) * r^2.
What you want is something like my_result = %dec(my_string) / 4
-----Original Message-----
From: Jeff Young [mailto:cooljeff913@xxxxxxxxx]
Sent: Thursday, March 24, 2011 10:30 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Help with %Dec
Given an 11 char field with the value of '00000639000', I am attempting to
use
%Dec to convert it to an 11.4 position numeric field.
new_value = %dec(char : 11 : 4).
I *want* the result to be 63.9000, but am getting 639000.0000 as my result.
What am I not understanding about how this works, and what would be the best
way
to get the desired result.
TIA,
Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions
V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical
Solutions Implementer V5R3
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.