Home » Developer & Programmer » Forms » formula (tabular layout)
formula (tabular layout) [message #347691] Fri, 12 September 2008 20:38 Go to next message
tjay
Messages: 37
Registered: September 2008
Member
Hi

I have a text item(10 records displayed)

For example;
When use enters 5 to the first record
and then 10 to the second record

(5*2)+(10*2)=30 must be displayed in the display item.

and user enter 3 to third record

30+(3*2)= 36 should be displayed in the display item.
and so on
How can I do that?
I have been trying to do this for one week, but I couldnt manage to succeed.

Re: formula (tabular layout) [message #347714 is a reply to message #347691] Sat, 13 September 2008 02:38 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It looks like a "loop through all records every time a new value is entered and do the computing" problem.

What did you manage to produce last week? Show us your attempt(s) which is the closest to the desired solution, explain why it doesn't work.
Re: formula (tabular layout) [message #347741 is a reply to message #347714] Sat, 13 September 2008 09:26 Go to previous messageGo to next message
tjay
Messages: 37
Registered: September 2008
Member
I want do this with 2 calculated items:

1-)formula item to return the result of ":block.item * 2"
2-)Summary item to add these which will be displayed.


For the first option:
I tried this formula but nothing displayed in displayed item

Calculation Mode: Formula
Formula: :CAB.VALUE*2
Summary Function:None
Sumarizedblock: Null
SummarizedItem: Null


Re: formula (tabular layout) [message #347937 is a reply to message #347741] Mon, 15 September 2008 02:18 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
In which block is this item?

David
Previous Topic: Oracle Forms 6 and Database 9i and Forms 6 and Reprots 6 (merged)
Next Topic: installation of developer suite on linux (suse11)
Goto Forum:
  


Current Time: Mon Feb 17 22:28:07 CST 2025