Count total price from child table and number order

[Uk]

Hello, I need a help again.

I have a table A as a parent and B as a child table.

first, I want to count the total price from the child table

second, I want to order number automatically from 1,2,3, etc

I tried some expressions but nothing happened. 

I need your help masters . thank you

[Lynn]

Hi @Uk 

Please show us the expressions you are having trouble with.

[Uk]

Hi @Lynn  I just accepted a solution , thank you so much

[Suvrutt_Gurjar · Accepted solution]

Please take a look at the sample app below for your first requirement.

Order Capture How-to

The Order table in the sample app has two columns Total Cost (Real column)  and Order Total (VC) that calculate total order cost.

For the second requirement , please do as follows.

The approach uses   @Steve 's  tip on getting the index number of an element in a list

INDEXOF() - Google Cloud Community

Please use @Steve 's index of expression in another VC called say [ Serial Number] in child table with an expression something like 

COUNT(
SPLIT(
ANY(
SPLIT(
(" , " & [Ref column in the child table B].[Reverse reference column in Parent Table A that has name like Related Child Tables ] & " , "),
(" , " & [Key Column of Child table B] & " , ")
)
),
" , "
)
)

[Uk]

Boomm, yes it works as usual. thanks @Suvrutt_Gurjar  you are amazing