FRM-30426
Hello All,
I have a situation where a grid which has 2 columns. One is Calculated by system. Other one use can add value to override system value.
At the bottom of the grid I have to display the sum. If manual column has a value then that should be included in sum else system generated value.
To implement this here is what I did:
In Grid block created a new formula column manual_or_system having formula NVL(:blk.manual_amt,:blk.system_amt)
I created a new block with properties as:
Query All Records: Yes
Single Record: Yes
Database Data Block: No (To make this block as control block)
I added a text item to this block which is set for calculation
Calculation Mode: Summary
Summary Function: Sum
Summarized Block: blk
Summarized Item: manual_or_system
When I generate FMX for this form I get error
FRM-30426: Summarized control item must reside in a control block, or in a block with Query set to Yes.
Item: manual_or_system
Block: blk
Can somebody help me here? Block blk is already a control block (because property "Database Data Block" is set to No) and Query All Records is already set to Yes.
I am not sure what else is the problem here?
Regards,
Saket Maheshwary