Need some help with formula

Hello,

I am Sylvain. I work in a french confectionnery. Not the unicorn candy company 🙂

I am building a cash flow monitoring and I have to import the bank book in a data module :

Only one line item is list formated : "compte"

Other are text, number or date

Sans titre.png

And the trouble is about the date. i have to take the data from the row "'dat.point".

But i only have the date on 1line by accounting entry (row "piece")

How can i complete the empty cell with the date? The date is always on the last line, like on the screenshot.

i was thinking about making a list with "Piece" but it's maybe overkill

or maybe using ISFIRSTOCCURRENCE ?

thx a lot!

Sylvain

Accepted answers

So the list is the way to go.

Thx a lot for the quick answer @Akhtar.shahbaz and @Misbah

have a nice day

Sylvain

I think creating a list and storing dates against list items should be the way to go. And then use LOOKUP to retrieve the dates into the module

Misbah

I am assuming that you have stored data in a flat list.

Step 1: Create the piece list

Step 2: Create another system module to store the data by piece via action, you can apply filter line item as a filter in your view.

Step 3. write a formula to lookup the value from sys module to the main module via lookup.

Hope this helps

Thanks

Akhtar

So the list is the way to go.

Thx a lot for the quick answer @Akhtar.shahbaz and @Misbah

have a nice day

Sylvain

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385