Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

The right code for an additional field....

Former Member
0 Likes
1,214

Hi all

Creating a query, I've written the follow code for the additional field "FATTURATO"

CLEAR FATTURATO.

FATTURATO = LFC1-UM01U + LFC1-UM02U +

LFC1-UM03U + LFC1-UM04U +

LFC1-UM05U + LFC1-UM06U +

LFC1-UM07U + LFC1-UM08U +

LFC1-UM09U + LFC1-UM10U +

LFC1-UM11U + LFC1-UM12U.

But the query lists a negative value for the additional field "FATTURATO"

What modication in the code should I put to change the value in positive?

Thanks

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,164

FATTURATO = LFC1-UM01U + LFC1-UM02U +

LFC1-UM03U + LFC1-UM04U +

LFC1-UM05U + LFC1-UM06U +

LFC1-UM07U + LFC1-UM08U +

LFC1-UM09U + LFC1-UM10U +

LFC1-UM11U + LFC1-UM12U.

FATTURATO = FATTURATO * '-1' .

7 REPLIES 7
Read only

Former Member
0 Likes
1,164

Multiply FATTURATO by -1.

Read only

Former Member
0 Likes
1,164
CLEAR FATTURATO.
FATTURATO = LFC1-UM01U + LFC1-UM02U +
LFC1-UM03U + LFC1-UM04U +
LFC1-UM05U + LFC1-UM06U +
LFC1-UM07U + LFC1-UM08U +
LFC1-UM09U + LFC1-UM10U +
LFC1-UM11U + LFC1-UM12U.
FATTURATO * -1.
Read only

Former Member
0 Likes
1,164

hi,

after writng your code,since the value is negative,multiply that value by (-1) so that you will get a positive value.

Thanks,

Sneha

Read only

0 Likes
1,164

how to do it in the code?

Read only

0 Likes
1,164

Do as ..

FATTURATO = FATTURATO * -1.

Read only

Former Member
0 Likes
1,165

FATTURATO = LFC1-UM01U + LFC1-UM02U +

LFC1-UM03U + LFC1-UM04U +

LFC1-UM05U + LFC1-UM06U +

LFC1-UM07U + LFC1-UM08U +

LFC1-UM09U + LFC1-UM10U +

LFC1-UM11U + LFC1-UM12U.

FATTURATO = FATTURATO * '-1' .