AnsweredAssumed Answered

Calculating a "pyramid"

Question asked by JesseVickey on Feb 10, 2017
Latest reply on Feb 14, 2017 by fmpdude

I'd like to calculate the "value" of a customer as the sum of all "value"s of customers they've referred -- essentially a pyramid (see the attached).

 

- In trying a simple self-join relationship with a sum calc, the value only goes 1 level deep.

- A "List" calc gives weird results.

 

Any suggestions?

Attachments

Outcomes