ACCUMULATOR NOT RESULT IN RIGHT SUM in case of repeated edges

GSQL
1

Hi TigerGraph teams,

I got a problem when trying to sum multiple transaction data in GSQL.

The data from RDB:

image
image1014×204 14.4 KB

But when I write the query like this, the accumulation result is only sum of 1 transaction only. (3k in totalTransinAMT)

How can I get the right TranInAmt of over 2e6

Thank for your helps.

2

image
image741×515 38.3 KB

Query and output in the picture

3

You are missing the details of the query, such as the declaration of the ACCUM @totalTransinAMT

Show the entire query and the details of the vertex attributes and the edges

4

image
image974×695 64.8 KB

This is the detail of query

5

image
image856×903 39.3 KB

This is how schema was define, quite simple. 1 Vertex and 1 edge

6

image
image1023×589 28.3 KB

This is how vertex was defined.

7

This is how data was mapped

image
image1408×607 57.2 KB

8

I will let others chime in, but I believe the issue is that you cannot have multiple edges of the same type between the same two source and target vertexes.

So this may be an instance where you want the transfer to be a vertex rather than an edge.