07-31-2008 2:43 PM
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
07-31-2008 3:08 PM
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' .
07-31-2008 2:44 PM
07-31-2008 2:46 PM
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.
07-31-2008 2:47 PM
07-31-2008 2:59 PM
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
07-31-2008 3:00 PM
07-31-2008 3:07 PM
07-31-2008 3:08 PM
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' .