topic Re: In Script calculating Total. in Application Development and Automation Discussions

In Script calculating Total.

Former Member — Thu, 27 Apr 2006 11:07:33 GMT

In scripts, when i am counting the total.

i need to print total as below

ex: if the total is 1234567, it should have print like 1,23,4567.00.

can anybody tell, how to do this.

Thanks

Re: In Script calculating Total.

Former Member — Thu, 27 Apr 2006 11:10:22 GMT

Hi chinna,

1. Declare your variable for total

data : tot type p decimals 2.

2. then automatically it will print as u want.

regards,

amit m.

Re: In Script calculating Total.

Former Member — Thu, 27 Apr 2006 11:12:19 GMT

hi Chinna,

Declare the field as type p

i.e, data: <b>p_var type p decimals 2.</b>

Regards,

Santosh

Re: In Script calculating Total.

Former Member — Thu, 27 Apr 2006 11:16:10 GMT

Hi,

you can declare the Variable as P then it will print as you want or else you see your User profile, if you have the parameter without comas then change it to 9,99,999,9999 .. then it will print the comas

Thanks

Sudheer

Re: In Script calculating Total.

Former Member — Thu, 27 Apr 2006 11:17:30 GMT

Hi Chinna,

try changing the settings in

menu system->user profile->own data

In that in the defaults tab you can specify the decimal Notation..

regards

satesh

Re: In Script calculating Total.

Former Member — Thu, 27 Apr 2006 11:18:14 GMT

Hi,

If it is total amount field,

then you can display it according to the currency.

Write <field> to <field type c> currency <currency>.

Thanks,

Rashmi.

Re: In Script calculating Total.

Former Member — Thu, 27 Apr 2006 11:25:22 GMT

Hi Chinna,

In Menu Bar,

(a) Click, System->User Profile->Own Data

(Now 2nd screen will be opened Automically)

(b) Click, "Default" TabStrip

(ii) Declare the field type as p.

Eg:- data: var1 type p decimals 2

Regards,

S. Manikanda.

Re: In Script calculating Total.

Former Member — Thu, 27 Apr 2006 16:07:06 GMT

Hi,

I am not sure how you have declared this variable inside the SMART Form, declare that in reference to a database amount field. Once you do that, it will take care of the formatting, by itself.

I am guess this is related to your old post.

Regards,

Ravi

Note :Please mark the helpful answers and close the post if resolved.

Re: In Script calculating Total.

Former Member — Wed, 03 May 2006 05:02:46 GMT

hi ravi,

first in the global declarations declare a variable say

wa_total like numc.

then go to tables in the calculation area

total the field name target field name and specify after loop.

this will print the total in each page and grandtotal in the last page.

try this out .

regards

rocky