Firstnonblank formula not working

Hi,

I'm trying to create a line item with the "firstnonblank" formula but it's not working.

I have 3 line item :

line item 1 = hub (let's say "1"or "2")
line item 2 = some text but not everywhere
line item 3 : i want to have the text of line item 2 but for each item in the same hub

I join a screen which is way more understandable.

A and B are text-formatted and HUB is list-formatted.

I was thinking doing something like line item 3 = Store receiving[FIRSTNONBLANK: Hub] to get my answer but it's not working ...

Do you have any idea why by any chance ?

Many thanks in advance !

anaplan_aide_71638.PNG

Accepted answers

All comments

rob_marshall

@Mariann ,

Create a new module dimensionalized by line item 1 (hub) and the formula should work.

Hope this helps,

Rob

Mariann

@rob_marshall

Many thanks for this quick answer !

Should I do a line item subset for this ?

Thanks,

Mariann

rob_marshall

@Mariann

No, a line item subset is not needed. Just create a new module with the "hub" list in the Applies to and then put your formula in referencing line item 2.

Rob

Mariann

Ok great, many thanks ! I'll try this right now

SuhasDesai

Is this working?

Quick Links

Can you help?

Unanswered questions

Rolling forecast
Hi , I have a requirement for my stakeholder to have a medium term forecast (by month for the next 6 months) and a more detailed rolling 15-week sales forecast by day which will then feed into the wider Supply Chain planning processes over time. This needs to be updated by the Sales representants for consolidation by the…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…