How to linksum the 2nd table of same name

Garfield

November 03, 2017 04:39

None

I try to link a table to get the linksum.

The linksum only retrieve from the base table, i want it to retrieve from the linked table.

=NL("Table","ausv_SMB_GL_TrxSumm_Open",{"ACCOUNT","DEPARTMENT","LinkSum([ausv_SMB_GL_TrxSumm_Open],[AA GL NET])"},"Link=","ausv_SMB_GL_TrxSumm_Open","ACCOUNT","=ACCOUNT")

The table is a list of Account Summary, but there are duplicate entries.

I want to create NL rows or Table to sum up the duplicate rows.

Someone please advise how to do it.

Date Votes

4 comments

0

Harry Lewis November 13, 2017 16:45

Have you tried using the Table Builder, specify the second table as the primary table? (and the "ausv_SMB_GL_TrxSumm_Open" table as the secondary table)?

Comment actions Permalink
0

Garfield November 24, 2017 02:59

Same issue

Comment actions Permalink
0

Garfield November 24, 2017 03:06

This is the table formula

Comment actions Permalink
0

Harry Lewis November 29, 2017 17:19

Hello Garfield -

Can you show some sample data and demonstrate what it is that you want to accomplish?

Comment actions Permalink

Please sign in to leave a comment.