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,132

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,082

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,082

Multiply FATTURATO by -1.

Read only

Former Member
0 Likes
1,082
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,082

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,082

how to do it in the code?

Read only

0 Likes
1,082

Do as ..

FATTURATO = FATTURATO * -1.

Read only

Former Member
0 Likes
1,083

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' .