2020 Apr 09 8:53 PM
Hi experts ,
I'm trying to delete zeros from a variable.
I have already tried
&variable(Z)&
and
&variable(.0)&
and
REPLACE ALL OCCURRENCES OF '.000' IN gv_amount_str WITH ' '.
But non of them is worked for my stituation.
If I give to variable as value 2,500 (with comma) , displaying as 2.500 (with dot).
But I want to display it as 2,5 (with comma).
Is there any idea please ?
Regards .
Hi experts ,
I'm trying to delete zeros from a variable.
I have already tried
&variable(Z)&
and
&variable(.0)&
and
REPLACE ALL OCCURRENCES OF '.000' IN gv_amount_str WITH ' '.
But non of them is worked for my stituation.
If I give to variable as value 2,500 (with comma) , displaying as 2.500 (with dot).
But I want to display it as 2,5 (with comma).
Is there any idea please ?
Regards .
2020 Apr 09 9:34 PM
Slight confusion
You said leading zeros and asking for comma instead of dot
Can you please show your requirement - screenshot.
is this value is numeric data type?
2020 Apr 09 9:50 PM
Hi
In form initialization section add the following statement.
SET COUNTRY 'GB' or 'US'
or you can use &variable(K)&Secondly,
&variable(.N)& Display up to N decimal places ( N can be 0)
&variable(C)& Compress Spaces
I hope both above you know it.
Just set the Country in Initialization tab of Form -
This will correct the dot / comma issue.
2020 Apr 10 7:50 AM