Welcome Guest Login SignUp

Home

Technical

Functional

CNC

AS400

DB2

    Citrix

JDE News

Live Radio

Feedback

JDE Forum Comments/Reviews/Queries
1801 day(s) ago   #209
Name: Nick
Category: Technical
Location: India
Date: 2015-09-03 20:22:20
Replies(0)

Status:
  #209

How to validate whether Number contains Decimals

We could use BSFN B0474N1 - Get Decimal Position. If return value is not equal to zero, that means, you have a decimal in the value. But this returns non zero value even though the number contains zero in decimal place e.g. 5.00.

mod() function could be used to check decimals in such case, sample code could be as below -

VA evt_mn = mod([FC mnFloat],1)
If VA evt_mn is equal to Zero
FC isWholeNum = "1"
Else
FC isWholeNum = "0"
End If

However standard way should be to use DD item which has data type to store whole numbers only (no value for display decimals).
Post Comments/Queries
Email:*
Name:*
Details:*
 
   
* Required Entry Field(s).  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
 
Disclaimer: Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).
Copyright © 2010 - 2020 JDEthread.in