on 02-07-2008 2:00 PM
one of the my field is curry type in database in report calculated something like balance if bal is < 0 then value print then after minus(-) sign so how it is ?
for example my calcluated value is 32,347.00-
now i want this type in script but in script only print like
32,347.00
so not print minus(-) sign
so pl tell how it is?
Use on variable of data type p with 2 decimals. move the value
which is having the minus sign to that variable and use this variable in form instead of that variable.
Reward if helpful.
Thanks.
Praveen.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Define the field as character field. then use the following code.
IF v_pack < 0.
t_fle-pack_doll = v_pack.
CONCATENATE '-' t_fle-pack_doll+0(15) INTO t_fle-pack_doll.
CONDENSE t_fle-pack_doll NO-GAPS.
ELSE.
t_fle-pack_doll = v_pack.
CONDENSE t_fle-pack_doll NO-GAPS.
SHIFT t_fle-pack_doll RIGHT.
ENDIF.
Hope it will solve your problem.
Thanks
Sarada
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.