Hi all, I have a module with a single multi-level list (category, subcategory, product). The 'all' level is called 'All Products' I need 'weight to parent' and a 'weight to all' line item formulas to use in my calculations. It's coming unstuck when i try to look up the 'denominator' for the weight calc. eg the value of the current item's parent, or the list total. It looks like i can't use item and lookup because the items reside in the same list the MDX syntax would be something like divide(measurename,(measurename,listname.currentmember.parent)) for the weight to parent & divide(measurename,(measurename,listname.all products)) for the weight to all is there an anaplan alternative? is there a different way i need to model my data to be able to retrieve the value of the current item's parent or the list total? Cheers