Forum Discussion
Parent and child calculation
i have a parent and child table, i wanted to calculate the values with respect to their root parents like a family tree Parent Child Value Site1 Site2 10 Site2 Site3 20 Site3 S...
AilleryO
Memorable Member
Memorable MemberHi,
Not 100% sure to understand your needs, but I suppose it's more complicated than your example.
If you need to take into account both levels Parent and Child, you should use 3 variables in your calculation, one for Parent, one for Child and one for Index (could be a date if you have one ?).
And basically you do your calculation, using filters like :
Parent=VARParent && Child=VARChild && IndexValue<=VARCurrentIndex
Hope it's clear enough, otheriwse do not hesitate to come back.