| Calculations [message #315688] |
Tue, 22 April 2008 07:34  |
*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 #315907 is a reply to message #315688] |
Wed, 23 April 2008 03:11  |
*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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
