OraFAQ Forum: Forms » calculating total in a block based on two other blocks

Home » Developer & Programmer » Forms » calculating total in a block based on two other blocks

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

calculating total in a block based on two other blocks [message #124403]

Sat, 18 June 2005 01:29

harmeet.gambhir
Messages: 30
Registered: June 2005

Member

hi everybody..

i have three blocks

1. PO block - a grand_total column
2. Indent Block - tabular block allowing challans to be selected - with only item_rate,item_status as check box columns updateble.
item_price column (a formula column of item_rate * item_qty)
total_amount : summary of item_price
3. Charge Block : tabular block for charges to be applied on total_amount in Indent block(each charge is total_amount+charge & so on)

the grand_total in PO block : total_amount(indent block) + total_charges(charge block)

the system shoul be in such a way that if any of the indent block or charge block is changed, the grand_total should automatically change.

pl. help me

thanks in advance

harmeet

Report message to a moderator