Skip to Content
0
Oct 31, 2019 at 10:09 AM

Simple Hierarchy formula question

70 Views

Hi everyone.

I'm new to SAC and so still trying to grasp some basics. I'm struggling with what should be a very simple formula.

I have a hierarchy that i want to reference in an "if formula" to enable me to group a few customers together. However i'm unable to find the correct identifier to validate the formula.

The Dimension is "Stock Code" and the parent I want to reference in the formula is "Customer" - I've tried (and failed) with many different variations that seemed logical but none are working.

I've attached a photo of the formula as i've written it, and also the hierarchy that shows the name etc.

Any help would be appreciated

Attachments

formula.png (35.3 kB)
hierarchy.png (74.1 kB)