Formula based on List top level

JAbhi

I have a module with one of the dimension as a list 'Prod Type', with items HW1, HW2 and this list has a top level 'All'.

In one of the line items in this module i want to apply a formula like below :-

If<top level of Prod Type> then <Task1> else <Task2>.

At first i thought of using parent(item(list)) as for top level this will return blank, but the module is having other hierarchical lists as well for dimensions due to which this formulation is not working for me.

Is there any work around for this?

pyrypeura

Hi @JAbhi you can use variation of this logic to accomplish what toy need. You can use IF level = 0 THEN logic else other logic in your formula then.

https://community.anaplan.com/discussion/33567/calculating-levels-in-a-hierarchy-for-dashboard-filtering

derektslim

Hello JAbhi

When you use an IF statement, the condition must return TRUE or FALSE.

Thus, you will need to create a checking condition.

IF

ITEM('Prod Type') = 'Prod Type'.'All'

THEN

<Task 1>

ELSE

<Task 2>

Then change the Summary method to Formula so it will apply at the All.

Hope this helps!

Derek Lim

JAbhi

Thanks @derektslim , its funny i was missing small detail of changing summary, but yes this works. thanks man :)

JAbhi

Thanks @pyrypeura - This article also works for me, and i believe it will be a good practice to follow this, but for more small and less complex structure the other answer by @derektslim fits well.

derektslim

It tends to happen, even to the best of us! 😂

Glad it works. Cheers!