I'm just getting started with Cypher and having a little trouble thinking about how to structure the query that I want.
Essentially, I start with a node (node A, we'll call it). Node A has an amount and is linked to Node B by Relationship of type 1. Node B is linked to Node C by Relationship of type 2, which has certain properties that may or may not match the properties of Node A, as well as a percentage property. As I go to Node C, I would like to multiply the amount from Node A by the matching relationship's percentage to get the relative amount at Node C. I would like to repeat this as I go to Node D, which is linked to Node C by Relationship 3, which has similar properties and also a percentage associated with it. I'm trying to figure out how I can write a query that will take the original amount and multiply it up the chain by matching the properties of each relationship.
Any pointers? I'm having trouble wrapping my brain around this new way of thinking, being used to relational databases, where I would do some kind of recursive query to calculate the effective percentage and multiply it by the original amount.