Home » Developer & Programmer » Forms » Calculations (Windows XP Oracle Forms 6i,)
Calculations Tue, 22 April 2008 07:34
 *munnabhai* Messages: 157Registered: 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?

Regards

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

Re: Calculations [message #315782 is a reply to message #315707] Tue, 22 April 2008 15:01
 Littlefoot Messages: 21130Registered: June 2005 Location: Croatia, Europe Senior MemberAccount 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
 *munnabhai* Messages: 157Registered: 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: Wed Jul 26 07:37:09 CDT 2017

Total time taken to generate the page: 0.08781 seconds