• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Aexp comparation with a literal doesnt work

arrozpegao

Active Member
hi all,
Just to check if it's only my "JDE".
I create a report with this event rule:

if BC AEXP IS GREATER THAN 100
whatever
en if

When AEXP=10 , whatever is execute. I had to change literal 100 with variable, and set variable to 100.

Is there something special comparing Mathnumerics fields with Literals?

THanks in advance.
PD: JDE Tools 9.1.4.7
 

Aarto

Reputable Poster
Howdy! What DD item did you base your variable on? It should be AEXP or similar with same number of display decimals Remember, AEXP has 2 (if memory serves correctly) display decimals so value shown in grid, as example 10,00, is actually stored as 1000 in the table
In your case, if you are using a generic math numeric variable, showing Aexp > 100 would be done like AEXP > 10000 (assuming display decimals is 2)

Hope this helps
Aarto
 
Last edited:

johndanter

Legendary Poster
I agree with Aarto. I would very rarely use any hard coded values. I too would use an internal variable and populate that to use in the compare. I guess it's kind of the same thing as hard coding but it's taking into account all of AEXPs DD format definitions and decimals etc
 
Top