CODEWITHSUNDEEP
neo4jcypher
jason
jason

Reputation: 3962

get difference between field values and sum in neo4j

How can I get difference between 2 fields: r.rating_val and rw.rating_val and sum of these fields using neo4j query?I really appreciate any help.

MATCH (a:user{id:"1"})-[r:`rating`]->(b),
 (w:user{id:"3"})-[rw:`rating`]->(b)
RETURN DISTINCT b,r.rating_val ,rw.rating_val

Upvotes: 0

Views: 696

Answers (2)

Vasu
Vasu

Reputation: 25

You can also use abs() function for difference.

    MATCH (a:user{id:"1"})-[r:`rating`]->(b),
     (w:user{id:"3"})-[rw:`rating`]->(b)
    RETURN DISTINCT b,
     abs(r.rating_val - rw.rating_val) as difference,
     (r.rating_val + rw.rating_val) as sum

Upvotes: 0

Luanne
Luanne

Reputation: 19373

Just subtract/add them in the return clause

MATCH (a:user{id:"1"})-[r:`rating`]->(b),
 (w:user{id:"3"})-[rw:`rating`]->(b)
RETURN DISTINCT b,
r.rating_val-rw.rating_val as difference,
r.rating_val+rw.rating_val as sum

Upvotes: 2

Related Questions