nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Flag list member based on whether it's referenced on a property of other list members

Alessio_Pagliano

Hi,

I'm sure I'm having a blond moment. What's the easiest way to achieve the equivalent of this Excel formula/situation (Column F), in Anaplan ?

Thanks!

Accepted answers

KirillKuznetsov

Better to split formula in two line items:

"Promo mentioned" = NAME(Promo copied from[FIRSTNONBLANK:Promo copied from])

"Value" = IF ISBLANK(Promo mentioned) then "not used" else Promo mentioned

All comments

KirillKuznetsov

Hi @Alessio_Pagliano

FIRSTNONBLANK must work. If isblank(Promo copied from[FIRSTNONBLANK:Promo copied from]) then "not used" else name(Promo copied from[FIRSTNONBLANK:Promo copied from])

KirillKuznetsov

Better to split formula in two line items:

"Promo mentioned" = NAME(Promo copied from[FIRSTNONBLANK:Promo copied from])

"Value" = IF ISBLANK(Promo mentioned) then "not used" else Promo mentioned

Alessio_Pagliano

Super! Thanks a lot @KirillKuznetsov , much appreciated!

Quick Links

Can you help?

Unanswered questions

Connection Problem with Excel Add-In Series 4 - No Customer
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
explainability results is blank into model
Why in my model output is blank, after send explainability data.
How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…