Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.
Help with Progress code
I am using a Software called Epicor that uses Progress Open Edge or 4gl. I am needing to do a rounding function on a number field that stores a "seconds since midnight value. What I need to do is take that value and convert it to a decimal and then round it up to the nearest quarter hour for clockin and down to the nearest quarter hour for clockout. What I have found is in the GUI if I take the number field And create a character calculated field I can translate the value to a time. Here is an example of the code that works
String(Integer(LaborHed.Nu
String(Integer(LaborHed.Nu
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Please use this -
REPLACE(String(Integer(Lab
This will give u 15.45
Explanation - Replace function will search for : and if found it will replace it with the . as expected in the question.
REPLACE(String(Integer(Lab
This will give u 15.45
Explanation - Replace function will search for : and if found it will replace it with the . as expected in the question.
Okay. Tested and that fixes my ":" problem and changes it to decimal. Awesome !!! Now if we can just get the rounding function in there we will be Golden. Will certainly give you credit for the help. Thanks a million. Is there a command for Ceiling like in Excel in Progress? I can do it in microsoft excel but do not know the syntax in Progress.
There are two functions in progress which can help us - Round and Truncate
can you give me a example what we have now and what is expected output.
can you give me a example what we have now and what is expected output.
Using your suggestion. REPLACE(String(Integer(Lab
Anything from .01 to .25 would round to .25. Anything from .26 to .50 would be .50. Anything from .51 to .75 would be .75 and anythig from .76 and up would round up. Example on the last. 7.76 would round up to 8.00
We have to like below -
We can use IF / Case.
We can use IF / Case.
--
IF MOD(OurNumber, 10) < 0.26 THEN ( OurNumber - MOD(OurNumber, 10) ) + 0.25
ELSE IF MOD(OurNumber, 10) > 0.25 AND MOD(OurNumber, 10) < 0.51 THEN ( OurNumber - MOD(OurNumber, 10) ) + 0.50
ELSE IF MOD(OurNumber, 10) > 0.50 AND MOD(OurNumber, 10) < 0.76 THEN ( OurNumber - MOD(OurNumber, 10) ) + 0.75
ELSE IF MOD(OurNumber, 10) > 0.75 THEN ( OurNumber - MOD(OurNumber, 10) ) + 0.50
--
Getting Syntax Error. What I did was replace "OurNumber" with "REPLACE(String(Integer(La
SyntaxError.docx
SyntaxError.docx
Please let me know if below if working or not ?
ASSIGN knum = DECIMAL(REPLACE(String(Int
ASSIGN knum = DECIMAL(REPLACE(String(Int
Yes it worked
Changed the calculated field type from Character to Decimal in the GUI and then put in this code.
Decimal(REPLACE(String(Int
Reading into it I think I just add this as "OurNumber" in the formula above?
Changed the calculated field type from Character to Decimal in the GUI and then put in this code.
Decimal(REPLACE(String(Int
Reading into it I think I just add this as "OurNumber" in the formula above?
Here is what I put in but still getting syntax error. I wonder if my GUI does not understand the MOD function?
IF MOD(Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")), 10) < 0.26 THEN ( Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")) - MOD(Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")), 10) ) + 0.25
ELSE IF MOD(Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")), 10) > 0.25 AND MOD(Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")), 10) < 0.51 THEN ( Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")) - MOD(Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")), 10) ) + 0.50
ELSE IF MOD(Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")), 10) > 0.50 AND MOD(Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")), 10) < 0.76 THEN ( Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")) - MOD(Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")), 10) ) + 0.75
ELSE IF MOD(Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")), 10) > 0.75 THEN ( Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")) - MOD(Decimal(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", ".")), 10) ) + 0.50
Only interface I have to work with is this one which is Progress code I think. Feel like it is so close The database is sql but as I understand it uses Progress Open Edge to translate from Progress to SQL.
please check if this is working..
ASSIGN knum = DECIMAL(REPLACE(String(Integer(LaborHed.Number01),"HH:MM") ,":", "."))
ASSIGN ref = DECIMAL(MOD(knum, 1))
I will try your last comment. I did not see it before. It may take a bit as I have to go to a meeting but will be back in a bit.
Sorry for not getting back to you sooner. Pulled many directions today. Will hopefully get back to this tomorrow. Thanks for all the help thus far as you have helped me almost all the way. I had to go in an manually fix the payroll records which took quite a few hours. I see on Experts-exchange you can be hired to help at 1.15/min. Not sure how to do that but thinking doing a webex with you might get me there faster.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial