OraFAQ Forum: Forms » How To Calculate Average in Forms 6i

Home » Developer & Programmer » Forms » How To Calculate Average in Forms 6i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How To Calculate Average in Forms 6i [message #502232]

Tue, 05 April 2011 07:14

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

How To Calculate Average in Forms 6i for example a summary column named (Amount = 5000) and i want to calculate 15% average of this amount i want to calcualte it like summary column pls guide me with some examples

Faheem

Report message to a moderator

Re: How To Calculate Average in Forms 6i [message #502236 is a reply to message #502232]

Tue, 05 April 2011 07:24

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not sure that "summary column" is capable of computing user-defined values. It can compute "average" values, but - in order to calculate 15% of something, you'll have to do that manually.

Report message to a moderator

Re: How To Calculate Average in Forms 6i [message #502800 is a reply to message #502232]

Sun, 10 April 2011 00:11

adeelali
Messages: 10
Registered: April 2011
Location: Pakistan

Junior Member

qanita786 wrote on Tue, 05 April 2011 17:14

How To Calculate Average in Forms 6i for example a summary column named (Amount = 5000) and i want to calculate 15% average of this amount i want to calcualte it like summary column pls guide me with some examples

Faheem

Faheem kindly try this
on Amount Item which = 5000

Trigger = 'When-Validate-Item'

Query = :sum := nvl(:amount, 0)*.15;

Thanks & Regards,
Syed Adeel Ali

Report message to a moderator

Previous Topic:	Report through Form
Next Topic:	Outlook Path

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 16:20:06 CDT 2024