Home » Developer & Programmer » Forms » Sum using Calculation property of forms
Sum using Calculation property of forms [message #78210] Mon, 28 January 2002 23:53 Go to next message
Anwer
Messages: 3
Registered: October 2001
Junior Member
I have two blocks in my form one is master and second is detail tabular. In tabular block i have some fields which i want to total or sum. by using Calculation property of forms. for that i make some non database item and make setting for summary item with defining summary block and item. it works perfectly but now i want to use round() function in it. because the answer i got in summary item is not properly rounded with .00. is there anybody give me a solution regarding how to use round() formula beside summary item with calculation preperty of forms ?.
Re: Sum using Calculation property of forms [message #78216 is a reply to message #78210] Tue, 29 January 2002 18:46 Go to previous message
dinakar shetty
Messages: 29
Registered: January 2002
Junior Member
HI
Y can set the format of the summary field
or where ever u are refering that field
use round(:txt_ss,scale)
Previous Topic: Re: free material for oracle
Next Topic: forms 6i (urgent)
Goto Forum:
  


Current Time: Fri Apr 03 06:55:16 CDT 2020