Home » Developer & Programmer » Forms » Calculations (Windows XP Oracle Forms 6i,)
Calculations [message #315688] Tue, 22 April 2008 07:34 Go to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Hi guyz,

I have three items in my form

i) qty
2) unit price
3) total ( display Item )
4) grand total (display Item)

when user enter the qty and unit price in total field
it should calculate the Qty * Unit Price how can i summarized this qty * unit price

its was displaying total and grand total perfectly the problem is Qty and unit price

and another thing how can we display the total amount in words?

Please help me

Regards

Re: Calculations [message #315707 is a reply to message #315688] Tue, 22 April 2008 08:45 Go to previous messageGo to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
hI GUYZ

Its solved......thanks in advance/////// Laughing
Re: Calculations [message #315782 is a reply to message #315707] Tue, 22 April 2008 15:01 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's really nice.

However, as you chose to keep the solution for yourself, noone can benefit from it. Would you mind to post it?
Re: Calculations [message #315907 is a reply to message #315688] Wed, 23 April 2008 03:11 Go to previous message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
You are rite Little, anyhow below is the details how i solve this problem.

Scenario:-
______________________________________
Qty Unit Price Total price
______________________________________
02 500.00 1000.00

_____________
tot Amt 1000.00
_____________

total price is the display item
in the total price property go to Calculation ->calculation mode set to Formula
then write a formula :blk_name.item_name * :blk_name.item_name its very simple

and in tot_amt set the calculation propery
Calculation mode --> summary
sumamry funtion --> Sum
summarized item --> tot_price

it will give tot_amt as above

thanks all.


Previous Topic: Need to dispaly a message on F8 function key
Next Topic: Sequence Number
Goto Forum:
  


Current Time: Sun Dec 11 02:38:56 CST 2016

Total time taken to generate the page: 0.08497 seconds