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

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…