Converting Field rule from A4 to A5

[pughdr]

Converting from Alpha4, V7 to Alpha5, V9. Need help in converting this field rule.

Parent=OP_CKHDR
Field Type Width Decimal Places

1. NUMBER C 8
2. DATE D 8
3. BILLCODE C 10
4. NAME C 40
5. AMOUNT N 10 2

Child=DETAIL
Field Type Width Decimal Places
2. NUMBER C 8
9. ACCTCODE C 15
10. DESC C 40
11. TAXABLE C 1
12. AMOUNT1 N 8 2

Field rule forOP_CKHDR->AMOUNT (Field 5)
Type : Numeric
Value : Summary
Summary of : DETAIL->AMOUNT1
Summary function : Total
Ignore Mode : None
Posting : Yes
Auto Advance : No

Tried total(Ck_Detail->Amount1,grp->ckhdr) and it works in the Expresion Builder but get the following error when I try to save.
"Cannot use function in this context" I need this value stored in the Parent Amount field.
Thank you in advance.

[Stan Mathews]

This function is a report writer function, not intended for table level field rules or other expressions. While the function may perform in some areas outside of the report writer, its use there is not supported.

You'll have to convert to a tablesum() or dbsum() expression.

I can't tell if your child table is "Detail" or CK_Detail".

Try
tablesum("Ck_Detail","Number = "+quote(Number),"Amount1")
or
tablesum("Detail","Number = "+quote(Number),"Amount1")

ass appropriate.

[pughdr]

Thanks for the help. Think my problem was my child was named Ck-detail. I renamed to Ck_detail and it works. Alpha must not like the -.

[Stan Mathews]

Alpha must not like the -.

Indeed not. How would Alpha decide if you were subtracting the values in two fields/tables or referring to a hypenated table name? Best to refrain from using punctuation in a name, underscores if you feel you must punctuate.